Re: SQL*FORMS ... how to start in query-only mode

From: Gv Fragante <fragante_at_unixg.ubc.ca>
Date: Thu, 2 Jul 1992 17:38:01 GMT
Message-ID: <fragante.710098681_at_unixg.ubc.ca>


In <DOWEN.92Jul1122145_at_russell.praxis.co.uk> dowen_at_praxis.co.uk (David Owen) writes:

>We did it recently on a project by invoking itself recursively. You need to write some 3GL code as
>a user-exit to test and set a variable inside the 3GL. Then on the pre-form trigger you call the
>the user-exit that tests to see if the global variable is set. If it is, you exit the pre-form
>trigger. If it isn't, you test the users access rights. If he is allowed general access, simply
>continue with the trigger. If he has read-only access, call the 3GL and set the global variable and
>then call the form again in query only mode. It seems to work quite well. NB. We used C for the
>3GL.

Thanks for the feedback. We decided to stick to the dummy parent form method. It is simpler and takes little overhead. All the dummy parent mode had was one dummy block with one dummy field and a two-line key-startup trigger.

As for a form calling itself recursively, if the form is quite large, won't it take up memory if it calls itself ?

GV Received on Thu Jul 02 1992 - 19:38:01 CEST

Original text of this message