Re: Sort Data, at runtime

Daniel,

in the POST-QUERY trigger for this datablock I'm running this code

BEGIN
   SELECT distinct description, segment1 INTO :ITEM_DESCRIPTION, :INVENTORY_ITEM_CODE
 FROM apps.mtl_system_items

    WHERE organization_id = :xxp_quotation_header.organization_id       AND inventory_item_id = :INVENTORY_ITEM_ID; EXCEPTION WHEN OTHERS THEN NULL;
END;          SET_RECORD_PROPERTY(:SYSTEM.TRIGGER_RECORD, :SYSTEM.TRIGGER_BLOCK, STATUS, QUERY_STATUS); This is what keeps them sync. Received on Thu Sep 09 2004 - 01:29:35 CDT