How to implement dynamic SQL in Forms?
From: Big John <johnnyngan_at_yahoo.com>
Date: Fri, 11 Dec 1998 09:54:33 +0800
Message-ID: <74pu3p$dfq3_at_news.hk.linkage.net>
Hi,
Date: Fri, 11 Dec 1998 09:54:33 +0800
Message-ID: <74pu3p$dfq3_at_news.hk.linkage.net>
Hi,
I would like to reuse the :system.last_query as a sub_query in a forms
procedure, so that I can count some number like the followings:
select count(col1) from table_a
[Quoted] [Quoted] [Quoted] where exists (select col1 from table_b where ......)
and the :system.last_query is exactly the sub-query statement. But forms
does not accept the syntax if I replace the sub-query to :system.last_query.
So what can I do?
Best Regards,
John
Received on Fri Dec 11 1998 - 02:54:33 CET