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.
However there is "isc_dsql_execute_immediate_m", maybe m stands for multiple :oP. Alas, I don't see any example of how to use it. May be you should ask their support center. ( Let us know when you have got their answer ) ------------ FIreHAzaR:-D West Java, Indonesia ----- 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?
