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,

  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

Original text of this message