On Mar 10, 2009, at 11:42 PM, Mayura S. wrote: > Hello Sir, > > I downloaded sqlite 3.6.11 code for my project in my organisation. > I'm not using the amalgamation code. I'm building the source code > files in unix environment. > > I'm not new to sqlite, I have earlier worked on 3.2.2. > My project need is very simple - to store and read data (persistent > data ). > Hence there are no complex/conditional queries or sorting of any kind. > > I'm building the code with following switches, hence scaling down > Sqlite as much as possible to cater only store and read data.
Many of the OMIT options are incompatible with the amalgamation. If you want to use the OMIT options, you must build from canonical sources. Please see the 3rd paragraph at file://localhost/Users/drh/sqlite/website/bld/doc/compile.html #omitfeatures > > > -DSQLITE_OS_OTHER=1 > -DSQLITE_THREADSAFE=0 > -DSQLITE_TEMP_STORE=3 > -DSQLITE_OMIT_AUTHORIZATION > -DSQLITE_OMIT_AUTOINIT > -DSQLITE_OMIT_BETWEEN_OPTIMIZATION > -DSQLITE_OMIT_BLOB_LITERAL > -DSQLITE_OMIT_BUILTIN_TEST > -DSQLITE_OMIT_CHECK > -DSQLITE_OMIT_COMPLETE > -DSQLITE_OMIT_DATETIME_FUNCS > -DSQLITE_OMIT_DECLTYPE > -DSQLITE_OMIT_DEPRECATED > -DSQLITE_OMIT_FLAG_PRAGMAS > -DSQLITE_OMIT_FLOATING_POINT > -DSQLITE_OMIT_GET_TABLE > -DSQLITE_OMIT_INCRBLOB > -DSQLITE_OMIT_INTEGRITY_CHECK > -DSQLITE_OMIT_LIKE_OPTIMIZATION > -DSQLITE_OMIT_LOAD_EXTENSION > -DSQLITE_OMIT_LOCALTIME > -DSQLITE_OMIT_PAGER_PRAGMAS > -DSQLITE_OMIT_PROGRESS_CALLBACK > -DSQLITE_OMIT_SCHEMA_PRAGMAS > -DSQLITE_OMIT_SCHEMA_VERSION_PRAGMAS > -DSQLITE_OMIT_SHARED_CACHE > -DSQLITE_OMIT_SUBQUERY > -DSQLITE_OMIT_TCL_VARIABLE > -DSQLITE_OMIT_TRACE > -DSQLITE_OMIT_TRUNCATE_OPTIMIZATION > -DSQLITE_OMIT_UTF16 > -DSQLITE_OMIT_XFER_OPT > -DSQLITE_OMIT_ALTERTABLE > -DSQLITE_OMIT_ANALYZE > -DSQLITE_OMIT_ATTACH > -DSQLITE_OMIT_AUTOINCREMENT > -DSQLITE_OMIT_AUTOVACUUM > -DSQLITE_OMIT_CAST > -DSQLITE_OMIT_COMPOUND_SELECT > -DSQLITE_OMIT_CONFLICT_CLAUSE > -DSQLITE_OMIT_EXPLAIN > -DSQLITE_OMIT_FOREIGN_KEY > -DSQLITE_OMIT_PRAGMA > -DSQLITE_OMIT_REINDEX > -DSQLITE_OMIT_TEMPDB > -DSQLITE_OMIT_VACUUM > -DSQLITE_OMIT_VIEW > -DSQLITE_OMIT_VIRTUALTABLE > -DSQLITE_SYSTEM_MALLOC > > > ... but I'm getting the following symbols as Undefined. > > Error: L6218E: Undefined symbol sqlite3CreateView (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3Vacuum (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3Pragma (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3Attach (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3Detach (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3Reindex (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3Analyze (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3AlterRenameTable (referred > from sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3AlterFinishAddColumn > (referred from sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3AlterBeginAddColumn (referred > from sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3VtabFinishParse (referred > from sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3VtabBeginParse (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3VtabArgInit (referred from > sqlite.ptl). > Error: L6218E: Undefined symbol sqlite3VtabArgExtend (referred from > sqlite.ptl) > > > The above symbols are not available in the '#else' code of any > compiler switch. Most of the compiler switch do not have any '#else' > code. > Please guide me on resolving these symbols. All the above symbols > are used in parse.c file. > I believe parse.c is a generated file. > Should I make changes in parse.c file ? OR > Should I stub those symbols in '#else' code ? > > Thanks in advance. > Mayura > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
