Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

dbAlias – PB Docs 126 – PowerBuilder Library

dbAlias – PB Docs 126

dbAlias DataWindow object property

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.

Controls

Column controls

Syntax

PowerBuilder dot notation:

Describe and Modify argument:

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:

Examples

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

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

See Also

dbName


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x