Re: Forms 3.0 Question - Assigning seq. numbers to query results

Gregory Smith (bigfoot_at_sequent.com) wrote:
> I believe you can use simple PL/SQL in the POST-QUERY trigger to
> assign the field the value of SYSTEM.CURSOR_RECORD which Forms3.0
> automatically assigns to each row in the Forms window:
 

> :field := :SYSTEM.CURSOR_RECORD;
>
> This will also cut an unnecessary SQL call out, improving performance.
 

> Let me know if this does not work. -G.

This is fine as long as records aren't created or deleted. If this can happen, then look in the Advanced Forms Techniques manual, which explains how to deal with this siuation.

--
 _________________________   __________________________________________
/  Tommy Wareing          \ /  I've been looking for an original sin,  \
|  p0070621_at_brookes.ac.uk  X   One with a twist and a bit of a spin    |
\  0865-483389            / \     -- Pandora's Box, Jim Steinman       /
 ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~