Subject Multiple dynamic sql statements supported?
Author Matthew Adams
Hi all,

Does Firebird 2.5 in embedded mode support dynamic sql that contains
multiple semicolon-separated statements?

I'm getting a "Token unexpected" error when I submit a multi-insert
command (using the .NET provider 2.5.2.0) as a single string
"insert into foo (id, amount) values (1,1); insert into foo (id,
amount) values (2,2);"

The error line & column numbers indicate the "insert" keyword in the
second statement.

Thanks,
Matthew

--
mailto:matthew@...
skype:matthewadams12
yahoo:matthewadams
aol:matthewadams12
google-talk:matthewadams12@...
msn:matthew@...
http://matthewadams.me
http://www.linkedin.com/in/matthewadams