Re: [Firebird-net-provider] batch query support

2007-06-01 Thread Nobuya Higuchi
Hi, Carlos > It's not supported. Thanks. I can live with that. Regards, Nobuya - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limit

Re: [Firebird-net-provider] batch query support

2007-06-01 Thread Carlos Guzmán Álvarez
Hello: > FB2.0.1/FBClinet2.0.1/.NET2.0 > > Is batch query supported with FB2.0/Provider2.0.1? By batch query, I mean > putting two or more SQL sentences into a single FbCommand (e.g. > FbDataAdapter's UpdateCommand) like: > > update xxx set x1 = @x1, ...; > select x1, x2, ... from xxx ... ;

Re: [Firebird-net-provider] batch query support

2007-06-01 Thread Jiri Cincura
On 6/1/07, Mercea Paul <[EMAIL PROTECTED]> wrote: > I think u can use 'EXECUTE BLOCK' for that Yes, execute block works fine. But you have to put it "manually". In designer it's not possible, 'cause VS is validating SQL in own way. :( -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://w

Re: [Firebird-net-provider] batch query support

2007-05-31 Thread Mercea Paul
ers > Subject: [Firebird-net-provider] batch query support > > Hi, > > FB2.0.1/FBClinet2.0.1/.NET2.0 > > Is batch query supported with FB2.0/Provider2.0.1? By batch query, I > mean > putting two or more SQL sentences into a single FbCommand (e.g. > FbDataAd

[Firebird-net-provider] batch query support

2007-05-31 Thread Nobuya Higuchi
Hi, FB2.0.1/FBClinet2.0.1/.NET2.0 Is batch query supported with FB2.0/Provider2.0.1? By batch query, I mean putting two or more SQL sentences into a single FbCommand (e.g. FbDataAdapter's UpdateCommand) like: update xxx set x1 = @x1, ...; select x1, x2, ... from xxx ... ; thanks in advance,