User Tools

Site Tools


prop_name_sql.htm
Navigation:  »No topics above this level«====== PROP:Name (SQL Properties) ====== Return to chapter overview

All of the SQL Accelerator Drivers now support the following syntax:

view{'field_label',PROP:Name} = string

to change the field's name in the generated SQL. This is normally a name that will be used for a field in a SELECT statement.

Example:

 PROGRAM

 MAP

 END

EMP       FILE,DRIVER('ORACLE'),NAME('EMP'),PRE(EMP)

P_EKY_EMP   KEY(EMP:EMPNO),NOCASE,OPT,PRIMARY

KEY_DEP     KEY(EMP:DEPTNO),DUP,NOCASE,OPT

Record      RECORD

EMPNO         SHORT !Emp-no

ENAME         CSTRING(11) !Employee name

JOB           CSTRING(10) !Job

HIREDATE      DATE !Hiredate

MGR           SHORT !Manager

SAL           PDECIMAL(7,2) !Salary

COMM          PDECIMAL(7,2) !Commisison

DEPTNO        BYTE

           END

         END

v VIEW(EMP)

   PROJECT(EMP:EmpNo)

 END

 CODE

   OPEN(EMP)

   OPEN(v)

 CODE

   OPEN(EMP)

   OPEN(v)

   v{PROP:Order}=SQL(1)

  v{'EMP:EmpNo',PROP:NAME} = 'count(*)'

   SET(v)

   NEXT(v)

   MESSAGE(EMP:EmpNo)

This example will produce the equivalent of “SELECT count(*) FROM EMP”.

See Also: PROP:SQL , PROP:Order

prop_name_sql.htm.txt · Last modified: 2019/11/13 16:57 by 127.0.0.1