Subject | Get . from OrderingItems |
---|---|
Author | Rick Roen |
Post date | 2005-01-13T14:33:34Z |
I have a routine that allows the user to select the ordering of a
query by clicking on the column header in an TIB_Grid fed by a
TIB_Query, and then select various modifiers so I can change the
SQLWhere in the query.
I'd like to get the qualified <tablename>.<fieldname> of the current
ordering so I can properly configure the where string into something
like Query.SQLWhere = 'Where <tablename>.<fieldname> starting with
(or like or containing) '?''
I know I can get the OrderingItemNo, but I'm not sure how to
get "PURCHASEORDER.PONUM" from the OrderingItems when the
OrderingItemNo = 2.
The orderingitems is like this:
VNAME=VENDOR.VNAME;VENDOR.VNAME DESC
PONUM=PURCHASEORDER.PONUM;PURCHASEORDER.PONUM DESC
DATE_PO=PURCHASEORDER.DATE_PO;PURCHASEORDER.DATE_PO DESC
ITEMNUM=PO_ITEMS.ITEMNUM;PO_ITEMS.ITEMNUM DESC
ITEMNAME=PO_ITEMS.ITEMNAME;PO_ITEMS.ITEMNAME DESC
DATE_ETA=PO_ITEMS.DATE_ETA;PO_ITEMS.DATE_ETA DESC
TIA
Rick
query by clicking on the column header in an TIB_Grid fed by a
TIB_Query, and then select various modifiers so I can change the
SQLWhere in the query.
I'd like to get the qualified <tablename>.<fieldname> of the current
ordering so I can properly configure the where string into something
like Query.SQLWhere = 'Where <tablename>.<fieldname> starting with
(or like or containing) '?''
I know I can get the OrderingItemNo, but I'm not sure how to
get "PURCHASEORDER.PONUM" from the OrderingItems when the
OrderingItemNo = 2.
The orderingitems is like this:
VNAME=VENDOR.VNAME;VENDOR.VNAME DESC
PONUM=PURCHASEORDER.PONUM;PURCHASEORDER.PONUM DESC
DATE_PO=PURCHASEORDER.DATE_PO;PURCHASEORDER.DATE_PO DESC
ITEMNUM=PO_ITEMS.ITEMNUM;PO_ITEMS.ITEMNUM DESC
ITEMNAME=PO_ITEMS.ITEMNAME;PO_ITEMS.ITEMNAME DESC
DATE_ETA=PO_ITEMS.DATE_ETA;PO_ITEMS.DATE_ETA DESC
TIA
Rick