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: