Re: Sort Data, at runtime

From: Iceman <econstantine_at_fattal.com.lb>
Date: 8 Sep 2004 23:29:35 -0700
Message-ID: <92c03dc2.0409082229.1e474b3e_at_posting.google.com>


Daniel,

[Quoted] 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 - 08:29:35 CEST

Original text of this message