PocketBuilder follows this order of precedence to supply the data in your DataWindow object:
If you have saved data in the DataWindow object, PocketBuilder uses the saved rows from the DataWindow object and does not retrieve data from the database.
PocketBuilder uses the data in the cache if there is any.
If there is no data in the cache yet, PocketBuilder retrieves data from the database automatically, with one exception. If the Retrieve on Preview option is off, you have to request retrieval explicitly, as described next.
If you do not want PocketBuilder to retrieve data from the database automatically when the Preview view opens, you can clear the Retrieve on Preview option. The Preview view shows the DataWindow object without retrieving data.
To be able to preview without retrieving data
automatically:
Select Design>Options from the menu bar.
The DataWindow Options dialog box displays.
Clear the Retrieve on Preview check box on the General page.
When this check box is cleared, your request to preview the DataWindow object does not result in automatic data retrieval from the database.
Retrieve on Preview check box is available in the wizards
During the initial creation of a DataWindow object, you can
set or clear the Retrieve on Preview option.
When PocketBuilder first retrieves data, it stores the data internally. When PocketBuilder refreshes the Preview view, PocketBuilder displays the stored data instead of retrieving rows from the database again. This can save you a lot of time, since data retrieval can be time consuming.
Because PocketBuilder accesses the cache and does not automatically retrieve data every time you preview, you might not have what you want when you preview. The data you see in preview and the data in the database can be out of sync.
For example, if you are working with live data that changes frequently, or with statistics based on changing data and you spend time designing the DataWindow object, the data you are looking at might no longer match the database. In this case, retrieve again to obtain the most current data.
You can explicitly request retrieval at any time.
To retrieve rows from the database:
Do one of the following:
Click the Retrieve button in the PainterBar
Select Rows>Retrieve from the menu bar
Select Retrieve from the Preview view’s pop-up menu
Supplying argument values or criteria
If the DataWindow object has retrieval arguments or is set
up to prompt for criteria, you are prompted to supply values for
the arguments or to specify criteria.
PocketBuilder retrieves the rows. As PocketBuilder retrieves, the Retrieve button changes to a Cancel button. You can click the Cancel button to stop the retrieval at any time.
The Data view displays data that can be used to populate a DataWindow. When the ShareData pop-up menu item in the Data view is checked, changes you make in the Data view are reflected in the Preview view and vice versa.
