Hello,
I am trying to use the Mono.Data.SqliteClient with sqlite3 but can not
execute more than one SQL command in a single CommandText:
SqliteCommand dbcmd = new SqliteCommand ();
..
..
dbcmd.CommandText = @"
CREATE TABLE table1 (
id TEXT,
name TEXT
);
CREATE TABLE table2 (
id TEXT,
name TEXT
);
";
This command creates table1 only (sometimes).
If it is only possible to use 1 command per SqliteCommand, is it ok to
use only one SqliteCommand instance through out the method?
Best regards.
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
