I've tried "isc_execute_immediate", having the idea of Database.Execute() instead of Query.Execute(), but that didn't work.
isc_dsql_execute_immediate_m has different parameters than other execute procs on gds32.dll, as read in IBase.h. furthermore, this function is not listed in IBExpress. if one would insist on having multiple queries, maybe this is the answer, but the documentation that I have, IB SDK from IB installation, doesn't provide any samples. newer version of MySQL support multiple queries as their way to provide faster execution, may be other server as well, but IB seems hasn't reached there yet. ------------ FIreHAzaR:-D West Java, Indonesia ----- Original Message ----- From: Fahri Reza I'm stuck with the same problem, I don't think it supports pipelining multiple queries.. I think it works like prepared statement in MySQL, optimized for a single query that is used frequently, with params and all. ----- Original Message ----- From: Wayne Hi All, I am writing some code that generates sql statements that I am then adding to the ibsql component in order to run the sql statement and update my database. My problem is that ibsql component does not seem to like the fact that there are numerous sql statements and not just one. When I write the sql statements to a memo component and then cut and past it directly to the database and run it there, the code works perfectly.. Any ideas?
