Re: ORACLE FORMS QUERY QUESTION

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