FORMREQUERY

This function will requery the current form.

FORMREQUERY(SQL // Mode // server)

PARAMETERS

SQL

The SQL Statement to requery form with.

Mode

The data modef that the form will be opened with

0 = Add Data
1 = Edit Data

2 = Read Only

Server

The server used to query against.  Note: Use “---“ for local device


Example:
To requery the current form for all records where field 'b' = 0:

FORMREQUERY("SELECT * FROM A WHERE b = 0"//1//"---")