Re: order of triggers in enter-query (forms 3.0)

I take it you are trying to check the user enters a valid date before issuing a query. A POST-CHANGE trigger won't fire in enter_query mode. The only way you can validate data in enter query mode is by creating a PRE-QUERY trigger. This fires when you press the execute query key but before the query is sent to the database. And yes I am still using FORM3 :).

Martin Cookson

Chris Eastwood wrote in message <7cqap2$ell$1_at_kraken.itc.gu.edu.au>...
>HiYa
>
>well a blast from the past (wonder if anyone else out there is still
maintaing
>forms 3 ... oh well)
>
>I have put a POST-CHANGE trigger on a field in a for that enforces a 4
digit
>date, and normally this works like a charm, however if the form is put into
>enter query, and then the field entered, and moved out of, the trigger
seems
>not to fire until AFTER exe-query (F3) is pressed.
>
>is this right?
>
>can I get the trigger to fire on the field during enter-query? maybe both
on
>enter and normal entry mode??
>
>thanks
>
>See Ya
>(when bandwidth gets better ;-)
>
>Chris Eastwood
>Photographer, Programmer email ua.ude.ug.cti_at_doowtsae.c
>Motorcyclist and dingbat
>
>please remove undies for reply
>************************************************************************
>Ohhh ... you work all day, slave over a hot stove all night
> yet you *still* have time for sadomasochism ... how do you do it?
>
>A little man hurts me.
>
><ding>
> Oh Mister Mean ... Oh Mister Mean
> 15 Minutes with him and you'll be blue and green
> Studded belts and leather whips
> Bondage trousers on his hips
> Wack and punish as you dust with Mister Mean
> Ohhhh he whips me around the house in minutes ... lets get cracking ...
Received on Sat Mar 20 1999 - 03:18:32 CET