f2s_index_sql_exists¶

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

Parameter	Description
FileNumber	Number of the file (filename.File_Number)
IndexNumber	Number of the index
variable	Boolean variable. True if created, false if not

Description

This read only attribute is used to verify if the index that maps to the DataFlex index was created correctly at the SQL backend.

Examples

get_attribute

Integer iIndex iDFIndexes
Boolean bCreated

Get_Attribute DF_FILE_LAST_INDEX_NUMBER of Customer.File_Number to iDFIndexes
For iIndex from 0 to iDFIndexes
  Get_Attribute f2s_index_sql_exists of Customer.File_Number iIndex to bCreated
  Showln "Customer.Index." iIndex ": " bCreated
Loop

Related Attributes

f2s_index_sql_name

Replaces: DF_INDEX_NATIVE_CREATED