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

[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 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 an

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 t

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

>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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit

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 http://s

Re: [sqlite] update on Ticket 3437

Nick, I think your query fails because there is a potential for multiple values on the right-hand side of WHERE RaceID=. Try this: WHERE RaceId = (SELECT DISTINCT ID FROM Races WHERE Name = 'totley moor' AND Date LIKE "2009%"); For that matter, wouldn't your query be better composed as: SELE

[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 th

[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 t

[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

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() &&

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

On Sat, 23 Jan 2010 22:57:24 -0800 (PST), greensparker 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 >load_extension('myfunction.so') . >Its worki