Subject Re: [IBO] Simple Question about delete clause
Author Svein Erling Tysvær
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