f2s_column_sql_name¶

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

Syntax

**There is no set_attribute.  This attribute is read only.**
get_attribute f2s_column_sql_name of {FileNumber} {FieldNumber} to {variable}

Parameter	Description
FileNumber	Number of the file (filename.File_Number)
FieldNumber	Number of the field
variable	String variable. Contains the name of the field

Description

This read only attribute is used to get the name of the requested column on the SQL backend. Typically, the field name on the SQL backend will be the same as the DataFlex name.

Examples

get_attribute

//find out what the column name on the SQL back end is for
//the dataflex field Customer.Name
string sName
integer iField

//use the DataFlex command Get_FieldNumber to get the field number for Customer.Name
Get_FieldNumber Customer.Name to iField

get_attribute f2s_column_sql_name of Customer.FileNumber iField to sName

Showln (SFormat("Customer.Name, field #%1 is %2 on the server", iField, sName))

Replaces: DF_FIELD_NATIVE_NAME