Kbase 18287: Using SQL functions in Apptivity e.g. MIN, MAX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/1/1998 |
|
Using SQL functions in Apptivity e.g. MIN, MAX
A statement such as:
select max(empno), min(sal) from emp
returns no data in Apptivity yet returns data when run in Oracle's
SQL*Plus: e.g. MAX(EMPNO) MIN(SAL)
7934 800
The statement "select max(empno), min(sal) from emp" is a valid
SQL statement, but Apptivity 2.1 requires alias for the
'functioned column'. For example, the above SQL can be written as
'SELECT Max(EMP.EMPNO) AS maxEMPNO, Min(EMP.SAL) AS
minSAL FROM EMP"
and the components can be bound to maxEMPNO and minSAL,
instead of max(empno) and min(sal). If you use the Apptivity
Query Editor, it will generate appropriate aliases automatically.