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 HFSQL Client/Server connections, only encryption can be managed by the ExtendedInfoproperty. .
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: 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 extended information about the Customer data file
Info(Customer.ExtendedInfo)
// Get extended information about the CustomerName item in the Customer data file
Info(Customer.CustomerName.ExtendedInfo)
Syntax
Finding out the extended information Hide the details
<Extended information> = <Data file/Item/Connection>.ExtendedInfo
<Extended information>: Character string
Extended information about the specified element. The different details are separated by semicolons (';').
<Data 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 (format: <Data file name>.<Item name>). 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
<Data file/Item/Connection>.ExtendedInfo = <Extended information>
<Data file/Item/Connection>: Character string (with or without quotes)
- Name of data file used. Name defined using the File description type.
- Name of the item used (format: <Data file name>.<Item name>). Name defined using 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 (';').