Was this helpful?
Go Operation--View Retrieved Records
After entering the data qualification and sort order specifications (if any), choose the Go operation on the Retrieve frame to display the data you have specified.
The operations available on the Retrieve frame while viewing data vary depending on the type of query target and whether the query target has a table field or simple fields.
View Retrieve Results for a Table
If the query target is a table in simple‑fields format, you view retrieve results one row at a time:
Next
Retrieves the next record.
Query
Clears the window of all retrieved information and allows you to start a new query.
Help, End
Standard operations.
The following figure shows query results for a table displayed on a form in simple‑fields format.
If the query target is in table‑field format, you can view multiple rows in the table field. The operations on the menu are Query, Help, and End.
After QBF displays all rows retrieved by your query, regardless of format, it displays the following message:
No more rows in query
View Sort Results for a Master/Master JoinDef
QBF displays the sorted results of a query on a Master/Master JoinDef with records from each table in simple fields or in table fields.
If the rows are displayed in simple‑fields format, click Next to display the next single record.
The following are operations for a Master/Master join with simple fields:
Next
Retrieves the next record (row) of data.
Query
Clears the window of all retrieved information and allows you to make another query.
Help, End
Standard operations.
If the rows are displayed in a table field, scroll through the data, if necessary, to see all rows. QBF displays an Out of Data message if you attempt to scroll past the end of the table field. You can suppress this message by changing the setting of the II_SCROLL_MSG environment variable/logical. For details, see the System Administrator Guide.
The following are operations for a Master/Master join with table fields:
Query
Clears the window of all retrieved information and allows you to make another query.
Help, End
Standard operations.
View Sort Results for a Master/Detail JoinDef
When you retrieve a master record in a Master/Detail JoinDef, QBF automatically retrieves all detail records associated with it. The master record is displayed in simple fields. The detail records display in either a table field or simple fields, depending on which format you chose when you created the JoinDef.
Regardless of the format, use the NextMaster operation to go from one master record to the next. Within each master you can view all associated detail records. If the display includes a table field for the detail records, QBF loads all detail records for a single master into the table field. If all the rows do not fit in your window, you can scroll through them. QBF displays an Out of Data message if you attempt to scroll past the end of the table field. You can suppress this message by changing the setting of the II_SCROLL_MSG environment variable/logical. For details, see the System Administrator Guide.
The following figure is an example of a retrieval for a Master/Detail JoinDef.
The preceding example includes a master row and its associated detail rows. The detail rows in the table field are sorted in ascending order, based on the Task column.
The following are the operations when records appear only in simple‑field format:
NextMaster
Retrieves the next master record.
Query
Clears the window of all retrieved information and allows you to make another query.
NxtDetail
Retrieves the next detail record.
Help, End
Standard operations.
Use the NextMaster operation to display a master record and the first detail record associated with it. Use NxtDetail to display the next detail record associated with the same master; the master data cannot change. If you choose NxtDetail when the last detail for that master has been displayed, QBF displays the following message:
No more details for this master . . .
It then retrieves the next master and its first detail record.
When QBF has displayed all rows delivered by your query, it displays the following message:
No more masters
No Rows Meeting Specifications
If QBF does not find any rows meeting the specifications in your query, it displays the message:
No rows found for this query
It then returns you to the Retrieve frame to enter a new query.
Last modified date: 01/30/2023