João Henrique Freitas writes:
 > My first question is: I can pass one query with many statements
 > together split by a semicolon? like above?
 > 

I didn't find a definitive answer to this question, but looking at the
Firebird API Guide makes me think the DSQL interface accepts only one
statement per call:

"SQL statement strings do not begin with the EXEC SQL prefix or end
with a semicolon (;) as they do in typical embedded applications"

I guess you're better off using separate calls and wrap them into
transactions.

regards,
Markus

-- 
Markus Hoenicka
markus.hoeni...@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Libdbi-drivers-devel mailing list
Libdbi-drivers-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel

Reply via email to