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