Re: How to implement dynamic SQL in Forms?
From: pepe <gasparp3_at_cpdav2.sc.mec.es>
Date: 16 Dec 1998 11:09:03 GMT
Message-ID: <01be28e4$5c5b62a0$ceec10ac_at_pcvita206.sc.mec.es>
Date: 16 Dec 1998 11:09:03 GMT
Message-ID: <01be28e4$5c5b62a0$ceec10ac_at_pcvita206.sc.mec.es>
you try use package procedure DBMS.SQL. This package is used for dynamic
SQL.
Big John <johnnyngan_at_yahoo.com> escribió en artículo
<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
> 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 Wed Dec 16 1998 - 12:09:03 CET