Re: dynamic UPDATE statement

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/03/06
Message-ID: <5fmrf8$k00_at_shadow.CSUFresno.EDU>#1/1

In article <331EFA93.2090_at_lilly.com>, Chris Halioris <halioris_chris_nonlilly_at_lilly.com> wrote:
>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.
>
>Use DBMS_SQL. Since you cannot call DBMS_SQL directly from Forms 4.5 you
>will have to create an intermediate stored/packaged procedure that you
>call from Forms that will make use of DBMS_SQL.

Forms_DDL is much simpler to use, and will do the dynamic updates from a form.

Regarding DBMS_SQL, most calls DO work from Forms, without the need for an intermediate stored procedure. Only a few calls to DBMS_SQL require a stored procedure. I have used DBMS_SQL heavily in the QA utility form to access multiple tables. It is especially useful when extracting data FROM a table. But for updating, I just used Forms_DDL.

Steve Cosner

---

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