GRIDREFRESH

This function will requery  the grid control on the current form.

GRIDREFRESH(SQL // RemoteTable // RemoteUniqueID // Server // Linkchild // Linkfield Master // Column Widths)

PARAMETERS

SQL

The sql statement used to populate the GRID.  If left empty, the settings currently defined will be used

Remote Table

The remote table that this sql is based on

Remote Unqiue ID

The remote field (unique field) that is used for updating data

Server

The server that this sql will be executed against.  Use "---" for the local device..

Linkfield Child

The name of a field in your GRID control. 

Linkfield Master

The name of a field in the main form.

Column Widths

The column widths in TWIPS.  ie.  To set the 1st 4 columns enter the following:  1000,2000,1500,4000.

EXAMPLE #1:
Refresh grid with data from the local table 'A':       
GRIDREFRESH("SELECT * FROM A"// // //"---"//////)

EXAMPLE#2:
Refresh grid with data from remote  table (abcDB™ ‘Wireless’ only)
GRIDREFRESH("SELECT * FROM myTable"//"myTable"//"myField"//"myServer"//////)