On Mon, 7 Nov 2011, Reinier Olislagers wrote:
On 7-11-2011 8:23, Reinier Olislagers wrote:2. You can apparently load the spatialite (and dependencies) dll/so as an extension to SQLite, with a statement like [3] select load_extension('libspatialite-4.dll'); However, it seems you have to enable the extension load mechanism first using the C API [2]: int sqlite3_enable_load_extension(sqlite3 *db, int onoff); (onoff==1 to turn extension loading on)Attached diff (against fixes_2_6) seems to work for letting SQLite load the libspatialite extension, e.g. using this in my Lazarus FormCreate event: // Try to load extensions DBConnection.DatabaseName:='osm.sqlite'; DBConnection.Open; DBConnection.LoadExtension('libspatialite-4.dll'); //Note: we need an open db before doing this Now I'm getting an error message saying that libfreexl-1.dll can't be found, apparently an Excel reader library required by spatialite... I'm going to ask the spatialite guys for clarification on this... I'll upload the diff as a patch unless somebody has objections/a better implementation...
Uploading the diff should be fine. Michael. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
