Re: KEY-ENTRY vs KEy-EXECUTE TRIGGER

In article <1992Jul2.101548.16859_at_nntp.hut.fi>, k33271c_at_taltta.hut.fi (Vesa Jaakko V{h{maa) writes:
> Hello SQL Forms (V3.0) Users!
>
> I'm having a bit of difficulty in figuring out the difference between
> KEY-ENTRY and KEY-EXECUTE triggers. It seems that when the user presses
> "Enter Query", then enters the criteria and finally presses "Execute Query",
> the KEY-EXECUTE-QUERY trigger does not fire. Why is that? Should the
> actions to be taken for query retrieval be placed under both of these
> triggers? Any clarifications are much appreciated.
>
>
> Thanks

When the [EXECUTE QUERY] key is used in conjunction with the [ENTER QUERY] key, its associated trigger is not supposed to fire. The only time this trigger will fire is when a "blind" query is run (i.e. the [EXECUTE QUERY] key is pressed without [ENTER QUERY]). Why?? I don't have any idea.

What I do if I have actions to take is create a user-defined trigger and call it from both of the above triggers. I think in V3 you can create a procedure, but I'm not very familiar with the nuances of V3 yet.

MLK Received on Mon Jul 06 1992 - 15:43:37 CEST