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