Re: How to see query

From: Kay Kanekowski <kkanekowski_at_mindcommerce.de>
Date: Mon, 23 Jul 2001 14:56:27 +0200
Message-ID: <9jhak0$1ld$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:56:27 CEST

Original text of this message