Re: ON-VALIDATE trigger in QUERY mode - SQL*Forms 3.0

From: Steven Whatley <swhatle_at_starbase.neosoft.com>
Date: 25 Jan 1995 13:57:56 GMT
Message-ID: <3g5ld4$6j6_at_uuneo.neosoft.com>

Tommy Wareing (p0070621_at_brookes.ac.uk) wrote:
: In Forms 3.0, NO triggers fire while in query mode, so the only
: solution for this is a pre-query trigger. Unfortunately, this leaves
: the poor user facing 29-JUN-0094 until they hit EXECUTE-QUERY, at which
: point the value magically changes.

There is another more painful option. That is to create a non-basetable query block which emulates QUERY mode.then when the user press <Enter Query>, they are put into the block which looks just like the normal one.

When the user presses <Execute Query> then the selection criteria is copied to the desired block in a PRE-QUERY trigger. Yeah, there is more coding and coordination needed but, it gives you all of the triggers you need.

Later,
Steven Whatley

 _   _  _ _  __ : Steven Whatley              \ The opinions expressed are my
|_  |_|  |  |   : System Analyst/Programmer    \ own.  You may freely copy,
 _| | | _|_ |__ : swhatle_at_starbase.neosoft.com  \_use,_or_ignore_them._______
                : Oracle CDE2 Ambassador: Ask questions about the CDE2 tools!

Scientific Applications International Corporation (An employee-owned company) Received on Wed Jan 25 1995 - 14:57:56 CET