Forms 4.5 : can the SQLquery-statement generated by forms be retrieved ?

From: Bas Grondhuis <grondhuisb_at_hotmail.com>
Date: 1998/10/20
Message-ID: <01bdfc71$b27d44e0$bd06eed4_at_default>#1/1


Hello everybody,

Can someone help me ? I want to have a report (reports 2.5) corresponding with a form (forms 4.5). Meaning : when I perform a query in my form and choose one of several order by options, I would like to have a report based on those same query-paramters and have the same ordering. So if I could retrieve the last query-statement generated by forms it self, save it to file with text io or tpu file or something like that and then use that file as an external query in my report it should get the trick done......only problem : I have no idea how to retrieve that generated statement.

N.B. I now that I can retrieve the query-parameters in the pre-query trigger, but then I would have to translate that myself into a query statement >

>300 would become where <column> > 300

RT%                       where <column> like 'RT%'
12                          where <column>  12 

etc.

That's a lot of work, so I'd rather not work this out. And even if I would have to work this out.....I think I'm getting obsessed with retrieving that generated statement !

Greetings and thanks in advance,

Bas Grondhuis

--
Received on Tue Oct 20 1998 - 00:00:00 CEST

Original text of this message