Yes, the delete is the DeleteSQL property of the IBO_Query.

Actually when I delete, the row does get deleted, however I get the
message "Invalid reference to delete". The row stays visible until
I refresh, and then it is gone.

Rick

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 12:35 AM 28/01/2005 +0000, you wrote:
>
>
> >Delphi 7
> >IBO 4.3
> >
> >I'm trying to delete a record from the following IBO_Query and get
> >the message "Invalid reference to delete".
> >
> >I can delete ok from the data view in the component itself, but
not
> >from the program.
> >
> >The PK for InvoiceItems table is IDNUM.
> >
> >The SQL is:
> >
> >SELECT II.IDNUM
> > , II.ORDERNUM
> > , II.INVOICENUM
> > , II.ITEMNAME
> > , II.ITEMNUM
> > , II.ETD_DATE
> > , II.QTY_ORDER
> > , II.QTY_SHIP
> > , II.UNITS
> > , II.COST
> > , (II.QTY_ORDER * II.COST) AS COST_ORDER
> > , (II.QTY_SHIP * II.COST) AS COST_INVOICE
> > , NULLIF(II.LOTNUM, 0) AS LOTNUM
> > , II.TREATMENT
> > , II.PACKING
> > , II.GERM
> > , II.DATEGERM
> > , II.NOTE
> > , II.COMPLETE
> >FROM INVOICEITEMS II
> >JOIN ITEMS I ON I.ITEMNUM = II.ITEMNUM
> >ORDER BY I.NON_SEED_ITEM, II.ITEMNAME
> >
> >And the Delete is:
> >
> >DELETE FROM INVOICEITEMS
> >WHERE
> > IDNUM = :OLD_IDNUM
> >
> >Any suggestions?
>
> Can you be a bit clearer about what you are doing?
>
> Where is this "delete"? Is it a separate object, a TIB_DSQL or a
> TIB_Cursor? Or is it a string in the DeleteSQL property of the
dataset?
>
> Or what....
>
> Helen