Re: ORACLE FORMS QUERY QUESTION
From: Steven P. Muench <smuench_at_oracle.com>
Date: Sun, 18 Apr 1993 21:03:53 GMT
Message-ID: <SMUENCH.93Apr18130353_at_hqsun4.oracle.com>
Product Manager Received on Sun Apr 18 1993 - 23:03:53 CEST
Date: Sun, 18 Apr 1993 21:03:53 GMT
Message-ID: <SMUENCH.93Apr18130353_at_hqsun4.oracle.com>
EUGENY -- In a PRE-QUERY trigger, use the COPY() built-in to assign a
given string (whatever it may contain) to a field in the block about to be queryied. If the field in question is called QUAL_CODE in the LINE_ITEM block, then a block-level trigger on the LINE_ITEM block would look like:Forms Development
--
-- Pre-Query on LINE_ITEM
-- BEGIN COPY( '# (value1, ...)', 'line_item.qual_code' ); END; Of course, the first argument could be any string which you may have "glued" together programmatically. In fact, the second argument (specifying the *name* of the destination field) could also be supplied as a CHAR variable which might have be derived as well. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Steve Muench Email: smuench_at_oracle.com
Product Manager Received on Sun Apr 18 1993 - 23:03:53 CEST