Re: Sort Data, at runtime

From: Iceman <>
Date: 8 Sep 2004 23:29:35 -0700
Message-ID: <>


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

   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