| **Navigation:**  »No topics above this level«====== PROP:Name (SQL Properties) ====== | {{btn_prev_d.gif}}[[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]]{{btn_next_d.gif}} |
|  ||

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 2.htm|PROP:SQL]] , [[order  set view sort order expression .htm|PROP:Order]]