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>


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:


--
-- 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
  Forms Development
  Product Manager Received on Sun Apr 18 1993 - 23:03:53 CEST

Original text of this message