I remember having the same problem with mono svn. I just used the same
command multiple times to execute each query element.
2005/11/29, Ecmel Ercan <[EMAIL PROTECTED]>:
> I am using Mono 1.1.10_1 installer on Ubuntu 5.10. This should be the
> latest official release.
>
> using System;
> using System.Data;
> using Mono.Data.SqliteClient;
>
>
> public class TestSqlite
> {
> public static void Main (string[] args)
> {
> string connString = "version=3,URI=file:test.db";
> SqliteConnection dbcon = new SqliteConnection (connString);
> dbcon.Open ();
>
> SqliteCommand dbcmd = new SqliteCommand (@"
> CREATE TABLE counter1 (
> transid INTEGER
> );
>
> CREATE TABLE counter2 (
> transid INTEGER
> );
>
> ");
>
> dbcmd.Connection = dbcon;
> dbcmd.ExecuteNonQuery ();
>
> dbcmd.Dispose ();
> dbcon.Close ();
> }
> }
>
>
> This creates only counter1.
>
> _______________________________________________
> Mono-list maillist - [email protected]
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
--
Kamil Skalski
http://nazgul.omega.pl
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
