Creating a Query Record Group at Design Time
To create a query record group at design time:
- In the Object Navigator, click the Record Groups
node.
- Click Create in the toolbar.
- In the New Record Group dialog, click Based on the Query Below and then
enter a SELECT statement in the Query Text field. The WHERE clause for the
SELECT statement can include references to global variables and form parameters.
- Click OK.
Oracle Forms validates the SELECT statement and dismisses the dialog.
Note: The new record group does not yet have any rows. The
rows are returned at runtime by the query associated with the group:
- You can execute the query associated with a query record group programmatically
by calling the POPULATE_GROUP Built-in subprogram.
- When an LOV is based on a query record group, Oracle Forms executes
the query associated with that record group whenever the LOV is displayed
or whenever Oracle Forms needs to validate a text item that has the
Use Validate from List property set to Yes.
Related topics
About record group Built-in subprograms
About manipulating a record group at runtime
Modifying an existing record group
Performing operations on rows
Viewing the structure of your record group
Modifying the SELECT statement for your query record group