Re: SQL*FORMS ... how to start in query-only mode
Date: Wed, 1 Jul 1992 08:17:12 GMT
Message-ID: <1992Jul1.081712.157_at_rz.uni-karlsruhe.de>
In article <fragante.709935857_at_unixg.ubc.ca> fragante_at_unixg.ubc.ca (Gv Fragante) writes:
>How I can invoke a form to function in query-only mode from SQL*MENU ?
>
>By default, the form is a data-enterable form, but I would like users with
>view-only privileges to look at the form as well without allowing them to
>update/delete/change.
>
>I know that this form can be invoked from a 'parent' form via CALL_QUERY(),
>but if I am invoking this form directly from SQL*MENU without a parent... how ?
>The only alternative I have is to create a dummy parent form to invoke
>the data-entry form in query-only mode. But I was wondering if there is a more
>elegant solution to this.
>
>Thanks.
Well, I'm just new at this stuff, but I just finished a view-only
form myself. I created views from my tables (using only the columns
necessary) and use the views as base tables in SQL*Forms (3.0).
This way no changes can be made on the original tables. It worked
for me.
Good luck.
Karen Received on Wed Jul 01 1992 - 10:17:12 CEST