Re: dynamic UPDATE statement

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/03/05
Message-ID: <5fj16s$8kk_at_shadow.CSUFresno.EDU>#1/1

In article <331b6fc7.28635423_at_news.innet.be>, <fs_at_tis.be> wrote:
>Does anyone know how to write a dynamic UPDATE statement in Oracle
>Forms 4.5. We want to create the WHERE-clause dynamically at runtime.
>
>Thanks for all suggestions.
>
>Carl Van de Casteele
>Koen Schaubroeck

Forms_DDL will do it. For example:
Forms_DDL('Update My_Table Set Column2=''Value1'',Column2=''Val2'''

        ||' where key_column=''keyvalue''');

If you get the correct number of apostrophes in the right places, it is easy.

The above example is what the QA utility form does.

Regards,
Steve Cosner

---

Try out my dynamic data utility form, QA. Quick display and update access to any table. http://members.aol.com/stevec5088 Received on Wed Mar 05 1997 - 00:00:00 CET