Re: Views

ccsajmk_at_bath.ac.uk (A J M Knight) wrote:

>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

Check out the Forms Libraries. I think the name of the package You need is DO_SQL.

Kersten Received on Fri Feb 02 1996 - 00:00:00 CET