Subject Re: [IBO] Simple Question about delete clause
Author Daniel Rail
In the help, it's mentionned that ExecSQL is just for BDE/VCL
compatibility, since in TQuery it's ExecSQL and not Execute. In Jason's
components, ExecSQL and Execute are the same.

Daniel Rail
Senior System Engineer
ACCRA Med Software Inc. (

At 09/04/2001 10:37 AM, you wrote:
>The help file states: "This property is used to supply a custom SQL
>statement that will take care of deleting the current row of the dataset." I
>guess that explains why it complains when deleting several rows.
>I think you're better off using a TIB_DSQL statement with your delete
>statement(s) and simply call ExecSQL or Execute (I've never understood the
>difference between these two).
>Gerhardus Geldenhuis wrote:
> > Hi
> > Believe it or not I have never done a fancy delete clause.
> >
> > Is deletesql the right property to modify when I want to
> > delete data out of a table(one or more rows). The deletesql
> > is property of a iboquery.
> > If I put my delete clause in the sql property i
> > get a error:error creating cursor handle
> > here is how my delete clause typically looks.
> >
> > delete
> > and linktype = 'GLASS'
> >
> > It works when I put it in the deletesql clause but gives me
> > an exeception :EIB_DataSetError "Multiple records deleted"
> >
> > Groete
> > Gerhardus
>Yahoo! Groups Sponsor
>Your use of Yahoo! Groups is subject to the
><>Yahoo! Terms of Service.

[Non-text portions of this message have been removed]