Re: [sqlite] how to load custom function from QT

On Sat, 23 Jan 2010 22:57:24 -0800 (PST), greensparker balamurugan.c...@gmail.com wrote: hi, im using DEBIAN,QT4.5.2 I have custom functions in sqlite,like ascii,ceil,floor etc. lib name is myfunciton.so. i have tested manually in sqlite3 command line by using, select

Re: [sqlite] how to load custom function from QT

I have tried select load_extension('mylib.so') through QSQLQUERY. But it fails, with following error. unknown function name LOAD_EXTENSION and for the API from QT i hav included sqlite3ext.h and following code QSqlQuery qmenu; QVariant v = qMenu.driver()-handle(); if (v.isValid()

[sqlite] update on Ticket 3437

Hi, I submitted this some time ago, see http://www.sqlite.org/cvstrac/tktview?tn=3437,39. I've just been messing about with this again and have found out what was happening. The following script demonstrates the problem and resolution: [begin bug2.sql] /* this command line will demonstrate

[sqlite] Editing the list of SQLite wrappers

The SQLite wrappers page states 'If you know of a driver or wrapper for SQLite that is not listed below, please feel free to add it to the list. Please indicate SQLite version(s) supported', emphasis mine. See: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers I have a new wrapper to add to

[sqlite] creating database from dump file within C code

Hi all, I am a newbie to sqlite! Is there a way to create and populate a sqlite database from an already created dump file within C code. thanks! _alen D. -- View this message in context: http://old.nabble.com/creating-database-from-dump-file-within-C-code-tp27295724p27295724.html Sent from

Re: [sqlite] update on Ticket 3437

Tom Holden wrote: Nick, I think your query fails because there is a potential for multiple values on the right-hand side of WHERE RaceID=. No, it fails because 20 != '20' Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] update on Ticket 3437

No, it fails because 20 != '20' And also possibly because Date LIKE 2009% should be Date LIKE '2009%' everywhere it appears. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] creating database from dump file within C code

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 alenD wrote: Is there a way to create and populate a sqlite database from an already created dump file within C code. Load the dump text so you have it as one long string and then call sqlite3_exec pointing to that string. Behind the scenes what

Re: [sqlite] update on Ticket 3437

You're right! I arrived at a failure of a different kind because I did not drop the Races table as per his script between adding the first record with ID='20' and the second with ID=20. If Races table contains two records, the first with ID='20' and the second with ID=20, his query fails, even

Re: [sqlite] creating database from dump file within C code

Thanks, it worked perfect! _alenD Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 alenD wrote: Is there a way to create and populate a sqlite database from an already created dump file within C code. Load the dump text so you have it as one long string and then

[sqlite] creating indexes

Hi, Should an index be created before insertions or after insertions?:super: thanks in advance! _alenD -- View this message in context: http://old.nabble.com/creating-indexes-tp27299680p27299680.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] creating indexes

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 alenD wrote: Should an index be created before insertions or after insertions?:super: What performance difference did you see after trying both options? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with