Re: Display only blocks in SQL*Forms

mjw_at_mailbox.eng.ufl.edu (Mike Wohlgemuth) writes:
>I need to create a form in which the user enters information
>to be used in a query, and the query results show up in a
>seperate block in the form. The form should allow them to
>enter the block and navigate through the results, but not
>allow them to edit the values in the results. I have RTFMed
>and cannot see any way to make all the fields in a block
>display only and still be able to enter the block. Am I
>missing something obvious?

Yes - how will the user enter that block in order to move amongst records?

Create a non-database field called POINTER in the block, make it enterable, and field #1 (so that validation does not occur on the first fields in the record when you enter the block). Create triggers which do this:

 ON-NEW-FIELD-INSTANCE:
   :POINTER := '>';
 POST-FIELD:
   :POINTER := ' ';
 KEY-NXTFLD:
   next_record;
 KEY-PRVFLD:
   previous_record;

and so on...

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy_at_vistachrome.com, andy_at_genie.geis.com.

"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72