Forms 3.0 Question - Assigning seq. numbers to query results

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.

busch1_at_llnl.gov (Jeff Busch) writes:

>1) I'd like to give each record retrieved in a query a sequential number.
>When I select rownum into a display-only field in a post-query trigger, each
>row is numbered 1.
 

>---
>Jeff Busch Internet busch1_at_llnl.gov
>Voice (510) 423-9134 Fax (408) 263-1360
Received on Fri Oct 08 1993 - 02:59:42 CET