SQlite in slingshot - error using query component

Hi Nate / everyone,

Has anyone else had problems using the SQlite query component?

I can create databases and tables just fine using SQlite commands when it comes to querying a table I've created I get error outputs.

Is it me or is there a problem with the component?

I'm running Grasshopper 0.90014 with Slinghsot 0.8.8.2. I've installed the System.Data.SQlite bundle to my global assembly cache in trying to fix this problem, but it had no effect.

Replies to This Discussion

Permalink Reply by Nathan Miller on March 31, 2013 at 9:40am

I believe the the problem is a syntax issue when you are creating the table.

"CREATE TABLE IF NOT EXISTS TestTable(id INT PRIMARY KEY, Column1 INT, Column2 TEXT);"

try...

"CREATE TABLE IF NOT EXISTS TestTable(id INTEGER PRIMARY KEY, Column1 INTEGER, Column2 TEXT);"

Permalink Reply by Tom Withers on April 2, 2013 at 1:39am

Thanks Nate!

One more question.

I have a large number rows to enter into my SQLite database (10,000+). The only way to do it is all at once, but this is taking quite a while. I would like to wrap all 10,000 database entries in a BEGIN; ... COMMIT; statement so that only one journal file is created for the whole process, instead of a journal file per row, which should speed things up. Is this possible using the slingshot SQLite command component? It seems to want to run one transaction per row no matter what I try.

Thanks!

RSS