..ExtendedInfo is used to get additional information:
- about a data file accessed by a Native Connector or HFSQL Client/Server.
- about an item accessed by a Native Connector or HFSQL Client/Server.
- about a connection. In this case, this property is equivalent to ..CtExtendedInfo.
This extended information can be modified for a file, a connection or an item defined by programming.
See the documentation supplied by the provider of the database for more details.
Important: At this time, this property can only be used with AS/400 data files (and items) and with HFSQL Client/Server connections. On the HFSQL Client/Server connections, only the encryption can be managed by ..ExtendedInfo.
This information is displayed in the data model editor:
- in the description window of a data file.
- in the description window of the items found in a data file.
- in the description window of a connection ("Analysis .. Connections...").in the description window of a connection: on the "Analysis" pane, in the "Connection" group, click "Connections".
This property can be used:
- in read-only for a file or for an item defined in the data model editor or by programming.
- in write mode for a data file defined by a programming or a connection.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
// Get the extended information about CUSTOMER file
Info(CUSTOMER..ExtendedInfo)
// Get the extended information about the CustomerName item found in CUSTOMER file
Info(CUSTOMER.CustomerName..ExtendedInfo)
Syntax
Finding out the extended information Hide the details
<Extended information> = <Name of File/Item/Connection>..ExtendedInfo
<Extended information>: Character string
Extended information about the specified element. The different details are separated by semicolons (';').
<Name of File/Item/Connection>: Character string (with or without quotes)
- Name of data file used. This name was defined in the data model editor or by the File Description type.
- Name of the item used (in <File name>.<Item name> format). This name was defined in the data model editor or by the Item Description type.
- Name of connection used. This connection can correspond to:
Defining the extended information Hide the details
<Name of File/Item/Connection>..ExtendedInfo = <Extended information>
<Name of File/Item/Connection>: Character string (with or without quotes)
- Name of data file used. This name was defined by the File Description type
- Name of the item used (in <File name>.<Item name> format). This name was defined by the Item Description type.
- Name of connection used. This connection can correspond to:
<Extended information>: Character string (with quotes)
Extended information about the specified element. The different details must be separated by semicolons (';').