dbAlias

Description

The name of the database column but with the table alias in place of the table name, if any. This value can be used to construct the update DataWindow syntax dynamically when an alias name is used for a table.

Applies to

Column controls

Syntax

Describe and Modify argument:

"columnname.dbAlias { = ' dbcolumnname ' }"

Parameter

Description

columnname

The name of the column for which you want the name of the corresponding database column qualified with the table alias name

dbcolumnname

The name of the database column associated with columnname qualified with the alias of the table name

Usage

DbAlias is the name of the database column in the format tablealiasname.columnname. The value of dbAlias does not include the quotes that can be part of the SQL syntax. This property can be used to construct update DataWindow syntax dynamically when an alias is used for a column name.


In the painter

You can specify an alias for a table in the SQL Select painter if you convert the SQL statement for a DataWindow object to syntax. Select Design>Data Source to open the SQL Select painter, then select Design>Convert to Syntax. In the text window that displays, add the alias name to the FROM clause using the syntax:

FROM tablename tablealiasname

Examples

Example 1

Suppose a report has the following SQL Select syntax, with the alias “emp” for the table “employee”:

SELECT "emp"."emp_id",
       "emp"."emp_fname",
       "emp"."emp_lname"
       "emp"."dept_id"
       "emp"."salary"
FROM "employee" "emp"  
WHERE ( "emp"."salary" > 50000 )

Then the following statements would return the string “employee.emp_id” in ls_name and the string “emp.emp_id” in ls_alias:

string strAlias, strName
strName = dw1.Object.emp_id.dbName

strAlias = dw1.Object.emp_id.dbAlias

strName = dw1.Describe("emp_id.dbName")

strName = dw1.Describe("emp_id.dbAlias")

See also

dbName