ChangeSql()

Previous Next

You can use the ChangeSql() method to adapt a column's "Values to Query" property at runtime. This property holds a query that is used to generate an allowed values list. This method also takes care of refreshing the value lists of display objects, which is the difference in functionality between this method and setting the XtNsql BaseColumn property. The context of this method is: Column display.

Syntax

ChangeSql(<SELECT statement>)

Parameters

SELECT statement

Query used to generate an allowed values list.

NOTE:

If the allowed values have been defined at domain level, or by a related column, the change is refused and an error message is generated.