Hi Prakash, It basically gives an sql error say unknown line 2 "Update"
But as I mentioned when I run those lines directly in the database it is fine. If there is a single sql statement then it works fine. Kind regards Wayne --- In advanced_delphi@yahoogroups.com, "Prakash Shirodkar" <[EMAIL PROTECTED]> wrote: > > HI Wayne, > Can you please share with use what error you are gettign . > > Thanks, > Prakash > > On Mon, Oct 27, 2008 at 6:39 PM, Wayne <[EMAIL PROTECTED]> wrote: > > > 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? > > > > TIA > > > > Wayne > > > > > > > > > > -- > Thanks, > Prakash Shirodkar >
