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. (www.filopto.com)

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).
>
>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
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=210544.1579876.3135161.1261774/D=egroupweb/S=1705007183:HM/A=776675/R=0/*http://ads.track-star.com/adspace.ts?ts=1;2;217;107_220_105_264>100c52ab.jpg
>100c52f1.jpg
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.

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