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

In article <D2qH6o.GK6_at_indy.net>, bstanek_at_indy.net (Brian Stanek) says:
>
>john deehan (john_at_deehan.demon.co.uk) wrote:
>:
>: Is it possible to get ON-VALIDATE triggers to fire when a form is in
>: QUERY mode ?
 

>: I am trying to fix a bug in SQL*FORMS 3 aaplication where queries
>: can be performed on field of type DATE. I would like to run a procedure
>: to force the date to be in the form 29-JUN-1994 when the user has
>: entered 29-JUN-94. At present, FORMS converts the aforementioned
>: date to 29-JUN-94
 

>In forms 4.0, the WHEN-VALIDATE-ITEM (aka on-validate-field) trigger
>fires during query. In forms 3.0, you must use either the POST-CHANGE
>(unsupported and being phased out) or the POST-QUERY.
>
>In your situtation, I would prob. use a POST-CHANGE.

I've already replied to John, and he has the problem under control. What he wants to do is allow the user to query on a date field with a format of DD-MON-YYYY, but only to enter 29-JUN-94 in the query field.

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.

 _________________________   __________________________________________
/  Tommy Wareing          \ /  I've been looking for an original sin,  \
|  p0070621_at_brookes.ac.uk  X   One with a twist and a bit of a spin    |
\  0865-483389            / \     -- Pandora's Box, Jim Steinman       /
 ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~