Re: How to see query

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Mon, 23 Jul 2001 18:19:21 GMT
Message-ID: <JUZ67.8$Rg7.1419_at_news2.news.adelphia.net>


while not an expert, I have a good book :), try

variable_name := :system.last_query;

or, if from an attached library use

variable_name := name_in('system.last_query');

"dbahelp" <jichacha_at_vayumail.com> wrote in message news:4f6b3ef2.0107221825.111ecc1b_at_posting.google.com...
> Forms 4.5 developer 2000 question here.
>
> Need some help from experts. I have 2 blocks in a form.
> there is no where clause in block property. I want to see
> default SQL QUERY whcih is executed by the forms when we press
 key-exequery
> button on forms. I want to see the query text. Is there any way to do this
 ?
>
> Thanks in advance.
>
> dbahelp
Received on Mon Jul 23 2001 - 20:19:21 CEST

Original text of this message