Subject | Multiple dynamic sql statements supported? |
---|---|
Author | Matthew Adams |
Post date | 2011-01-13T16:47:55Z |
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
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