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
----*/