--- Liam Healy <[EMAIL PROTECTED]> wrote: > Thanks. I have included your changes in extension-functions.c so now > sqlite3_load_extension is usable. I had been using > sqlite3RegisterExtraFunctions which is not the official interface, and > that is why I never encountered this problem. Also, I have improved > the Mac OSX instructions for those that use Macs. > > The new version has been uploaded to sqlite.org/contrib.
The following patch allows extension-functions.c to be compiled as either as a standalone shared library extension module, or statically (against the sqlite3.h/sqlite3.c amalgamation) depending on whether COMPILE_SQLITE_EXTENSIONS_AS_LOADABLE_MODULE is #defined. I tested it against http://www.sqlite.org/contrib/download/extension-functions.c?get=22 from 2007-09-28 16:25:46 and it seems to work. --- extension-functions.c-orig 2007-09-28 12:52:13.000000000 -0400 +++ extension-functions.c 2007-09-28 12:52:13.000000000 -0400 @@ -87,8 +87,12 @@ //#if SQLITE_WITH_EXTRA_FUNCTIONS +#ifdef COMPILE_SQLITE_EXTENSIONS_AS_LOADABLE_MODULE #include "sqlite3ext.h" SQLITE_EXTENSION_INIT1 +#else +#include "sqlite3.h" +#endif #include <ctype.h> /* relicoder */ @@ -1618,8 +1622,7 @@ ** functions. This should be the only routine in this file with ** external linkage. */ -int sqlite3_extension_init(sqlite3 *db, char **pzErrMsg, const sqlite3_api_routines *pApi){ - SQLITE_EXTENSION_INIT2(pApi); +int RegisterExtensionFunctions(sqlite3 *db){ static const struct FuncDef { char *zName; signed char nArg; @@ -1748,6 +1751,15 @@ return 0; } +#ifdef COMPILE_SQLITE_EXTENSIONS_AS_LOADABLE_MODULE +int sqlite3_extension_init( + sqlite3 *db, char **pzErrMsg, const sqlite3_api_routines *pApi){ + SQLITE_EXTENSION_INIT2(pApi); + RegisterExtensionFunctions(db); + return 0; +} +#endif /* COMPILE_SQLITE_EXTENSIONS_AS_LOADABLE_MODULE */ + //#endif map map_make(cmp_func cmp){ ____________________________________________________________________________________ Don't let your dream ride pass you by. Make it a reality with Yahoo! Autos. http://autos.yahoo.com/index.html ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
