HI, you cannot run multipal queries from componets .
either you have to runt earch query puttign componets in loop or you can create dynamic database storedprocedure at run time. and assign same stored proedure to database componets and execute it. this will solve your problem. Thanks, Prakash On Wed, Oct 29, 2008 at 4:33 AM, mikcaau <[EMAIL PROTECTED]> wrote: > --- In advanced_delphi@yahoogroups.com<advanced_delphi%40yahoogroups.com>, > "Fahri Reza" <[EMAIL PROTECTED]> > wrote: > > > > 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? > > > > I don't think that Interbase or Firebird support multiple SQL > statements. They do support transaction management so that several > queries can run sequentially within the same transaction and succeed > or fail atomically. > > Mick > > > -- Thanks, Prakash Shirodkar
