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).

HTH,
Set

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
> FROM BILLOFMATERIAL
> WHERE WORKSORDERNO = 1
> 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