Re: How to see query

From: Anette Hansen <Info_at_AHa-EDV.de>
Date: Mon, 23 Jul 2001 10:42:01 +0200
Message-ID: <9jgo0p$794$1_at_ds10701a.msro.detemobil.de>


"dbahelp" <jichacha_at_vayumail.com> wrote in 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

Hello,

yes, you switch in debug mode and go step by step. But it's shure : select <your_table_items>,... from <your_table>

What's your problem? (no rows) check the name and item properties (Number,Char,length),
switch item's basetable off, execute the querry.

Regards, Anette Received on Mon Jul 23 2001 - 10:42:01 CEST

Original text of this message