ChangeSql()

Previous Next

Changes the value of a column's "Values to Query" property dynamically at runtime. This property holds a query that is used to generate an allowed values list.

Calling ChangeSql() also takes care of refreshing the value lists of any objects displayed. This contrasts with the result of (re)setting the XtNsql BaseColumn property.

Syntax

ChangeSql( select-statement )

 

The required select-statement is a query that defines the new list of values for the "Values to Query" property.

IMPORTANT: If allowed values have been defined at the underlying Domain or Column level (in USoft Definer), an error is raised.