Retrieve Information from the Cache

The values stored in a cache variable can be displayed in any label, literal, textbox or dropdown list control using the CACHE function. 

Step 1:  In the Layout Editor, select a table control.

Step 2:  In the Property Sheet, Queries section, select the appropriate query and open the Query Wizard (Edit…).

Step 3:  In the Query Wizard, add a new WHERE clause containing a formula that restricts the contents.  For example, to display the contents related to the most recently placed order, specify a formula in the Query Wizard, e.g.:

= CACHE(“OrderID”)

Step 4:  Build and run the application.

See Also

Common Formula Examples