Re: KEY-ENTRY vs KEy-EXECUTE TRIGGER

In article <5741.2a584e09_at_hayes.com>, mkrieger_at_hayes.com writes:
> 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.

the reason is that after [enter query], the [execute query] key merely terminates the enter-query mode. although it's the same physical key, it is actually used for two different purposes, the other being the "blind" query. I agree that it's weird, this explanation can help a lot.

>
> 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.
>

this is correct.  

> MLK

--