Re: Display only blocks in SQL*Forms

From: Richard Holowczak <holowczk_at_rwja.umdnj.edu>
Date: 16 Jan 93 19:38:26 GMT
Message-ID: <1847_at_rwja.umdnj.edu>

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?
 

>Mike

1. Try placing a dummy field in the results block which is enterable and use it for navigation up and down the rows extracted from the query.
2. Call a second form with the query using the 'callqry xyz' command where 'xyz' is the name of a second form. The callqry command will display the results but if the user tries to change and values, they will get a warning message and no changes will be made.
3. Disable the commit key.

Rich Holowczak                       holowcza_at_andromeda.rutgers.edu

Rutgers University
Ph.D. Computers and Information Systems Program

+---------------------------------------------------+---------------+
|  For best results, squeeze .sig from the bottom   | Ask about the |
|           and flatten as you go up.               | car alarm FAQ |
+---------------------------------------------------+---------------+

Received on Sat Jan 16 1993 - 20:38:26 CET