SQL_REFRESH_CACHE

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

For optimization during record retrieval, a set number of records are stored in a local cache. This command forces a refresh, by making the next find retrieve the record from the database instead of the cache.

Syntax

SQL_REFRESH_CACHE OF {FileNumber}

Parameter

Description

FileNumber

The number of the file

Example

Open Customer

Find gt Customer by Index.1
While (Found) Begin
    showln "Customer name is " CUSTOMER.CUSTOMER
Loop

SQL_REFRESH_CACHE of CUSTOMER