Dynamic SQL

From: Wicksey <Wicksey_at_hotmail.com>
Date: 25 Feb 1999 17:13:50 GMT
Message-ID: <01be60e2$32a608d0$0159ea9e@mothergoose>

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 - 11:13:50 CST