Re: ENTER_QUERY (other than page 1) v3.0

From: Michael P. Stein <mstein_at_access.digex.net>
Date: 3 Aug 1993 12:34:33 -0400
Message-ID: <23m42p$1pc_at_access.digex.net>


     After I emailed the narrow answer (no, ENTER_QUERY mode deactivates all key and field triggers) to the poster, I realized I had answered the wrong question. Since the answer is more general than the poster's question, I thought it would be of general interest.

     You can completely modify Enter Query key behavior *if* you're willing to do a lot of work. The technique is smoke-and-mirrors - instead of doing an ENTER_QUERY, you create a "fake" block - a control block (one without a base table) which looks exactly like the real block, but on another page or set of pages. Program KEY-ENTQRY to go to this block. You can then have instant field validation, effective KEY-Fn triggers (which could be set to go directly to other pages), even cross-block queries. Program KEY-EXEQRY on the fake block to go to the real block and do EXECUTE_QUERY; PRE-QUERY on the real block copies in the query values from the fake block. Of course, there's a lot of messy details to take care of like turning off all the keys in the fake block which would not be allowed in real ENTER_QUERY mode, etc. But it can be done.

-- 
Mike Stein			The above represents the Absolute Truth.
POB 10420			Therefore it cannot possibly be the official
Arlington, VA  22210		position of my employer.
Received on Tue Aug 03 1993 - 18:34:33 CEST

Original text of this message