SET FILTER example

The following example sets a filter based on the state that is chosen from a combobox on a form:

PROCEDURE setFilter_onClick

   private cState 

   cState = form.stateCombobox.value 

   set filter to STATE == "&cState" 

Note the use of macro substitution inside a literal string. A private variable is used; you cannot use the macro operator on a local variable. For example, if the variable contains the value "CA", then the macro substitution would evaluate to:

set filter to STATE == "CA"