I agree what you are showing here looks correct.

Do you have any more clues?

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Rick Roen
> Sent: Tuesday, April 26, 2005 5:16 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Invalid reference to delete
>
>
>
>
> I'm getting an error I can't figure out.
>
> I have a TIBO_Query component with the following delete statement:
>
> DELETE FROM ORDERITEMS
> WHERE IDNUM = :IDNUM
>
> From my Delphi 7 program I call: the Delete method and I get the
> message: "Invalid reference to delete".
>
> If I refresh the dataset, the record has actually been deleted.
>
> Below is the SQL monitor output, which all seems in order.
>
> Can someone point me in the right direction?
>
> Rick
>
>
> /*---
> EXECUTE STATEMENT
> TR_HANDLE = 16486648
> STMT_HANDLE = 16544160
> PARAMS = [ Version 1 SQLd 1 SQLn 1
> [IDNUM] = 48200 ]
>
> SELECT COUNT: 1
> DELETE COUNT: 1
> ----*/
> /*---
> COMMIT RETAINING
> TR_HANDLE = 16486648
>
> SECONDS = 0.010
> ----*/
>