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.

To get the recnum name, pass 0 as the column number:

string sFieldName

get_attribute f2s_column_sql_name of iFile 0 to sFieldName

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 DF_FILE_RECNUM_NAME if 0 is passed as the column number.