Re: Re - Executing the last user defined query in a form?

Couldn't you store the selection criteria away into GLOBALs and then re-populate the record towards the end of your PRE_QUERY trigger. Of course, the setting of the globals would also need to be performed within the PRE_QUERY so you'd probably need to have a flag to determine whihc 'form' of pre-trigger you are attempting, i.e. either a new query to save or a rerun of the last query.

Should work. Make my cookie chocolate chip.

--
Alan D. Mills

Mark S. Reichman wrote in message <35ab4a9e.0_at_news.rlcn.rl.af.mil>...
>How would a programmer re-execute the last query performed
>in a SQL 3.0 form by a user with code. I know if you
>press the keys.. [Enter Query] [Enter Query] [Execute Query] in
>a form the last user defined query will re-execute. However,
>when the previous is put into a trigger it hangs on the first
>[Enter Query] waiting for the user to type something into a field..
>
>Sooo... Any solid Ideas would win you a cookie.. Thanks...
>
Received on Tue Jul 14 1998 - 07:56:18 CDT