Salesforce

VarDbName (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

VarDbName (Magic xpa 2.x)

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)

Reference
Attachment 
Attachment