Hi,
I want to retrieve from SQL the inventory descriptions listed in Inventory Maintenance, Other, Descriptions.
I need it in the same order they appear in the grid. In Jiwa it appears the sort order is via the key (k1, k2, k3 etc).
I thought if I just order IN_Description by LineNum it would be in the same order as the grid but that isn't the case. Is there some way I can extract the descriptions in SQL by using the key, or at least get it in the same order?
SELECT * FROM IN_Description WHERE InventoryID = 'ABCD1234' ORDER BY LineNum is not returning the same order as the grid.
Cheers
Danny