Subject Get . from OrderingItems
Author Rick Roen
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