Views

Is it possible to create a view on a table at runtime from within a PL/SQL block in Forms 4.5?
I tried and got an error message about reserved words and create.

What I actually want to do is display in the Form the results of a query resulting from a number of criteria that a user enters.

The default Oracle query mode where the user fills in various text items on the Form is too simple forthe query and letting my users bring up an editor and enter a query is beyond most of my users!

Alternatively if a view cannot be created at runtime can I put the results of a query into a record group and display these in text items on the Form?

Any help gratefully received.

Adam Knight Received on Wed Jan 17 1996 - 00:00:00 CET