Placeholders in SQL Statements

Previous Next

See Also

A SQL statement that is used in a web page can contain these placeholders:

· The getValue placeholder reads a value from the selected record in a web page. This can be a column value of the selected record, or the current value of a variable in a variable set.

 

· The getSearchValue placeholder is used to retrieve values from query conditions.

 

· The getDataSourceAlias placeholder is used to refer to the (USoft-generated) alias of a data source in a SQL statement.

 

· The getMainDataSourceAlias placeholder is used in the WHERE clause of a SQL statement, and refers to the (USoft-generated) alias of the main data source in the FROM clause.

 

· The getThisDataSourceAlias placeholder is used in the WHERE clause of a SQL statement, and refers to the (USoft-generated) alias of the data source itself.

 

• The getWhereClause placeholder is used in the WHERE clause of a SQL statement, and copies the WHERE clause of another data source based on the same table to the appropriate data source.

 

• The getExpression placeholder is used to copy the Output Expression of a table column to use it in other expressions.

 

• The getSelection placeholder is used in the WHERE clause of a SQL statement, and creates an expression of the selected record of another data source based on the same table.

 

· host variables (e.g. :field) are used in the SELECT and WHERE clause of a SQL statement, and refer to a parameter that is set by the setHostVar() JavaScript function.