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.
|