Calculation
All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/Components for this Example |
Function SET189B or form S_189FB
You can use the SELECT_SQL statement to perform calculations on the retrieved data:
SELECT_SQL FIELDS(#SURNAME #SALARY (#STD_AMNT 'SALARY * 1.10')) FROM_FILES((PSLMST))

You can use the SELECT_SQL statement to perform calculations on the retrieved data:
SELECT_SQL FIELDS(#SURNAME #SALARY (#STD_AMNT 'SALARY * 1.10')) FROM_FILES((PSLMST))

Type | Name | Code | Description |
Function | SET189B | SET189B | SELECT_SQL - Calculation |
Form | S_189FB | S_189FB | SELECT_SQL - Calculation |