|
Queries a given data view to retrieve the physical definition of each variable.
|
|
Syntax:
|
VarDbName(variable index)
|
|
Parameters:
|
variable index – A value representing a variable index. Should be used with the VAR literal.
|
|
Returns:
|
String:
-
If the variable is a field of an SQL table, the function returns the table owner, the table's physical name, and the column's physical name of the defined variable, delimited by a period.
-
If the variable is defined in a Direct SQL statement, the function returns the field description.
-
If the variable is not a field of an SQL table, the function returns an empty string.
|
|
Example:
|
VarDbName('C'VAR) returns the Table1.CUSTOMER_ID, which is the name of the variable as defined in the database.
|
|
Note:
|
VarDbName is relevant only for fields of SQL tables. The function returns a blank string when evaluating fields from a Btrieve or Memory table, or a local variable that is not part of a Direct SQL statement.
|
|
See also:
|
Var functions
The Online and Rich Client Samples projects (program VA11 and RVA11)
|
