Alexey Pechnikov wrote:
> Original SQLite source tree has "ext " directory for extensions and I did
> place my extensions into this directory
>
> $ ls sqlite3-3.6.20/ext
> async billing compress empty env fts1 fts2 fts3 functions iconv icu
> inet key md5 README.txt rtree tablefunc undo uuid versioning
> virtualtext
>
>
Ok! That's good to know. Now I understand better.
Based on your comments I reversed the changes to determine the essential
ones. Here's the one that fit's with your corrections and works:
Best. gcc -fPIC -lm -L../iconv/ -c -shared virtualtext.c -o
libsqlitevirtualtext.so. The -c command is essential.
Now I want to load the library. Spatialite doesn't cover loading the
extension because it loads with the database. It starts with creating
the Virtual Table.
Here is what I tried and the errors:
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .load libsqlitevirtualtext.so (also tried
'libsqlitevirtualtext.so')
Error: %1 ist keine zulässige Win32-Anwendung.
Query: SELECT load_extension('libsqlitevirtualtext.so'); - executeStep
failed
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code:
0x80004005 (NS_ERROR_FAILURE)
SQLiteManager: Query: select load_extension('libsqlitevirtualtext.so',
'auto_load'); - executeStep failed
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code:
0x80004005 (NS_ERROR_FAILURE)
Thanks for help to move me along- Gary Gabriel
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
