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.

Return Values

Numeric

Remarks

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

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

See Also

CREATE SQL VIEW | SELECT - SQL | USE | CREATE QUERY Command