f2s_index_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_index_sql_name of {FileNumber} {IndexNumber} to {variable}

Parameter	Description
FileNumber	Number of the file (filename.File_Number)
IndexNumber	Number of the index in DataFlex
variable	String variable. The name of the index on the SQL server back end.

Description

This read only attribute is used to get the name of the index on the SQL backend that corresponds to the numbered index in DataFlex. All indexes in SQL are stored as names. DataFlex, on the other hand, stores indexes as numbers.

Example

get_attribute

String sIndexName
integer iDFIndexes iIndex

get_Attribute DF_FILE_LAST_INDEX_NUMBER of Customer.File_Number to iDFIndexes
for iIndex from 0 to iDFIndexes
  Get_Attribute f2s_index_sql_name of Customer.File_Number iIndex to sIndexName
  Showln "Customer.Index." iIndex ": " sIndexName
loop

Related Attributes

f2s_index_sql_exists

ESQL Equivalents

Replaces: DF_INDEX_NAME