REQUERY( ) Function

  • Article

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 Value

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

Remarks

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

See Also

Reference

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

Other Resources

Functions