I think u can use 'EXECUTE BLOCK' for that Regards, Paul
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Nobuya Higuchi > Sent: Friday, June 01, 2007 12:40 AM > To: For users and developers of the Firebird .NET providers > 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. > FbDataAdapter's UpdateCommand) like: > > update xxx set x1 = @x1, ...; > select x1, x2, ... from xxx ... ; > > thanks in advance, > 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 limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider