Dynamic SQL

From: Wicksey <Wicksey_at_hotmail.com>
Date: 1999/02/25
Message-ID: <01be60e2$32a608d0$0159ea9e_at_mothergoose>#1/1


Could someone please give me a brief overview of using dynamic SQL in forms 4.5?

Here is what I want to do:

Use the values of different variables in my procedure to determine which SQL statement to execute, then use that statement to populate a temporary table.

I think that using cursors would require me to declare 3 different cursors and then declare 3 different cursor loops all with the same code inside which seems a bit silly.

Any ideas would be most welcome.

Many thanks,

Wicksey Received on Thu Feb 25 1999 - 00:00:00 CET

Original text of this message