Start the Update Operation
You can start the Update operation from the operating system or from the Ingres Menu.
To start the Update operation from the Ingres Menu
1. Choose Queries.
2. Choose QBF.
The QBF Start‑Up frame displays. Choose QBFNames, JoinDefs, or Tables for the appropriate Catalog frame.
Note: When working with a table query target, choose SimpleFields or TableField format.
3. Place the cursor on the name of your query target in the Catalog frame and choose the Go operation. QBF displays the QBF Execution Phase frame.
4. On the QBF Execution Phase frame, choose Update.
QBF displays the Update frame, containing an appropriate query form for the query target you chose. At the top of the Update frame query form is the name of your query target.
The Update frame provides the following operations for use with the query form:
Go
Executes the query.
Blank
Clears the current entries from the frame.
LastQuery
Displays your last query specification for editing.
Order
Sets the order of rows for sorting.
ListChoices
Lists the available choices for the selected field on a QBFName.
Help, End
Standard operations.
5. Specify the row(s) you wish to retrieve for updating by filling in the appropriate fields on the Update frame query form. This procedure works in the same way as filling out the form on the Retrieve frame, as described in the chapter “Working with QBF Operations.”
6. Choose Go to display the data that matches your specified criteria. You can then modify or delete this data as explained in Modifying Data and Deleting Data.
If QBF does not find any rows meeting your specifications, it displays the following message and returns you to the Update frame query form to enter a new query.
No rows found for this query
The chapter “Using QBF” discusses steps 1 through 4 in more detail.
Last modified date: 11/09/2022