Replaces a field name in the SELECT clause of the current SQL query with a new one.
Note: SQLQuery class methods are used in the After table initialized event.
Syntax
replaceField(replaceableField, calculatedField, alias)
Arguments
replaceableField
a field name to be replaced. Example: "size".
calculatedField
a new field name. Example: "new_size".
alias
an alias of the new field name.
Note: the alias parameter can be omitted. In this case, replaceableField value is taken as alias.
Return value
No return value.
Example 1
Replace the 'name' with the 'englishName' as 'name':
query.replaceField("name", "englishName");
Example 2
Replace the 'price' with the 'price*1.2' as 'price':
query.replaceField("price", "price*1.2");
See also:
