> I'd like to figure out why the example > with half function which was provided by sqlite team can't be loaded as a > shared library.
Yeah, it's poorly documented. I'll just put this in the wiki: http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions&t=1180475067&diff=1 How To Build a Loadable Extension Shared Library on Linux 0. untar latest sqlite3 source code in a new directory 1. cd to the newly untarred sqlite directory 2. Comment out the line in Makefile.in to enable loadable extensions: # TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1 3. ./configure LIBS=-ldl && make sqlite3 4. export LD_LIBRARY_PATH="`pwd`:$LD_LIBRARY_PATH" 5. gcc -I`pwd` -shared src/test_loadext.c -o half.so 6. ./sqlite3 SQLite version 3.3.17 Enter ".help" for instructions sqlite> .load half.so testloadext_init sqlite> select half(7); 3.5 ____________________________________________________________________________________Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
