DROPREFRESH

The function will refresh the data in one of the dropdown boxes on your current form.

DROPREFRESH(tag // SQL // Server // Remote Index// Distinct)

PARAMETERS

tag

The TAG value of one of the dropdown controls on your form. 

SQL

The sql statement used to populate the dropdown control.  A hard coded set of values may also be used by entering a comma delimited list of values.  Always ensure that both the SQL and the Hard-coded list are surrounded by double quotes

Server

The Server used to query against .. use --- for the local device

Remote Index

The remote index (Only used for remote tables ... otherwise leave blank).

Distinct

1 = Only show distinct values
0 = Show ALL values
NOTE:  In order for DISTINCT to work properly, you must ensure that your SQL returns data sorted ASCENDING.

Example#1:
To fill the dropdown with a field from the table myTable located on your device, you would enter:

DROPREFRESH(DROPDOWN1 //”SELECT myField FROM myTable”//---//)

Example#2:
To fill the dropdown with a hardcoded list of Months, you would enter:

DROPREFRESH(DROPDOWN1 //"Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec"//---//)