Page 1 of 1

Multiple INSERT INTO

Posted: 19.09.2008, 13:18
by tatamata
Hi!
1. Is it possible to execute multiple INSERT INTO table (fields) VALUES (..), using Zeoslib and how?
2. I have a procedure which dynamically creates SQL string "INSERT INTO" and executes it for every row seperately. If I generate SQL strings first for all rows and the execute multiple "INSERT INTO.." in one step, would it increase performance?

Posted: 19.09.2008, 13:51
by mdaems
For scripts there is the ZSQLProcessor component. Just write the sqlscript in a string. Set the Script property (just once, that should be more efficient than adding line by line). Call the execute method.
Not sure if it would increase performance. Statements would be fired one by one to the database anyway.

Mark