Perhaps it would be easier to ask what should I have in these
properties?

The Join in this query is only for purposes of the Order by, where I
am using the I.NON_SEED_ITEM to sort along with II.ITEMNAME.

I have the following settings:

KeyLinksAutoDefine: unchecked

KeyRelation: INVOICEITEMS

KeyLinks: INVOICEITEMS.ITEMNUM=ITEMS.ITEMNUM

KeyDescLinks: blank

JoinLinks: blank

SQL:

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

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 02:48 PM 28/01/2005 +0000, you wrote:
>
>
> >Still no joy.
> >
> >When I erase the DeleteSQL and set the KeyRelation to
INVOICEITEMS,
> >I get "blank SQL statement not allowed".
> >
> >When I try the "IDNUM = :IDNUM" in the DeleteSQL I still get the
> >same message: "Invalid reference to delete".
> >
> >I have KeyRelation set to auto define
>
> KeyRelation doesn't have "auto define".
>
> >and the KeyRelation property left blank.
>
> KeyRelation should contain the name of the (one) table that is to
be
> updatable/deletable/insertable.
>
> >Should something be here?
>
> Are your KeyLinks accurately defined? KeyLinksAutoDefine won't
help you
> for a joined set...
>
> Helen
> >