Re: How to see query

From: Kay Kanekowski <kkanekowski_at_mindcommerce.de>
Date: Mon, 23 Jul 2001 14:36:13 +0200
Message-ID: <9jh5th$l7v$1_at_fermi.tro.net>


Hi,

try to create a 'post_select' - trigger on the form, firing after the original trigger:

  message ( 'Post_Select ' || :system.current_block || ' <Last_Query>' ||

             GET_BLOCK_PROPERTY (:system.current_block , last_query) || '<Last_Query>', acknowledge);   message ( 'Post_Select ' || :system.current_block || ' <Begin-Where-Clause>' ||

             GET_BLOCK_PROPERTY (:system.current_block , DEFAULT_WHERE) || '<End-Where-Clause>', acknowledge);

After this, every time you activate 'F7' / 'F8' you could see the last query and the actual default-where-clause.

But as Anette said, the where-clause will be empty.

hth
Kay

Mail: kkanekowski_at_mindcommerce.de Received on Mon Jul 23 2001 - 14:36:13 CEST

Original text of this message