Scripting with data sources
You can use the following functions to script around data source objects.
The DefaultDataSource placeholder
Each page has a default data source. This is the data source object that has its Default Data Source property set to Yes.
The getDataSourceAlias placeholder
In a SQL statement, the getDataSourceAlias placeholder is used to refer to the (USoft-generated) alias of some data source.
The getExpression placeholder
This placeholder is no longer supported in USoft 11.
The getMainDataSourceAlias placeholder
The getMainDataSourceAlias placeholder is used exclusively in WHERE clauses, and refers to the (USoft-generated) alias of the main data source in the FROM clause.
The getThisDataSourceAlias placeholder
In a SQL statement, the getThisDataSourceAlias placeholder is used to refer to the (USoft-generated) alias of the current data source.
The getSearchValue placeholder
This placeholder is no longer supported in USoft 11.
The getSelection placeholder
This placeholder is no longer supported in USoft 11.
The getValue placeholder
This placeholder is no longer supported in USoft 11.
The getWhereClause placeholder
This placeholder is deprecated in USoft 11 but still functional on data sources on the current main page.