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