PDA

View Full Version : need help with sqlite


qwer
08-14-2007, 03:17 PM
i'm trying to run the sample to the sqlite with datagrid. when i try to open the northwind.db file that comes with if it works fine, but when i try to open a diffrent *.db file (i created with sqlite browser) i get the error:
"on click,line 10:First argument to sqlite.querytotable() must be a database handle". what am i doing wrong?
i simply want first of all to see if i can open my database using the sqlite plugin.
i attached the sample file i'm talking about.

bule
08-15-2007, 03:56 AM
Which sqlite browser version did you use?
If you used the one that creates 3.x version databases, it won't work.
You need 2.x database version.

qwer
08-15-2007, 08:46 AM
not sure. anyway i only need a sqlite software i could build a database with and need it to work with the sqlite plugin.

usernameCasper
08-15-2007, 10:22 AM
I know TJ_Tigg offered us a link to a freeware application on sourceforge.
I think this is it, I used in the past the same program, take a look at http://sourceforge.net/projects/sqlitebrowser/
Maybe this is what you want ?

Take note what Bule said in earlier reply in this thread, have notice of the version you use.

Kind regards,
-Casper

qwer
08-15-2007, 11:19 PM
still no good. i guess the sqlitebrowser uses sqlite 3. it seems i need one that supports 2.0 . any suggestions?