Links are not active on this page.
 REQUERY( ) Function

Retrieves data again for a SQL view.

REQUERY([nWorkArea | cTableAlias])

Parameters

nWorkArea

Specifies the work area in which the SQL view is open.

cTableAlias

Specifies the alias of the SQL view. If you omit nWorkArea and cTableAlias, the data for the SQL view open in the currently selected work area is retrieved.

Expand imageReturn Value

Numeric. REQUERY( ) returns 1 if the data is successfully retrieved; otherwise, it returns 0.

Expand imageRemarks

REQUERY( ) is typically used to refresh a SQL view when data has changed on the data source.

Expand imageSee Also