PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • ExtendedInfo and connection
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
ExtendedInfo (Property)
In french: InfosEtendues
Native Connectors (Native Accesses)HFSQL Client/ServerAvailable only with these kinds of connection
..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.
Example
// 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)
<Extended information>: Character string (with quotes)
Extended information about the specified element. The different details must be separated by semicolons (';').
Note: The list of extended information recognized by OLE DB and the Native Connectors is presented in Optional connection information.
Remarks
WINDEVWEBDEV - Server codeWindows MobileAjaxUser code (UMC)HFSQL Client/Server

ExtendedInfo and connection

The information returned by ..CryptMethod is automatically updated when the information regarding the encryption of a HFSQL Client/Server connection is modified by ..ExtendedInfo (and conversely).
Therefore, the following code line:
MyConnection..CryptMethod = hCryptRC5_16
will modify the ENCRYPTION option in the string of extended information.
Similarly, the following code line:
MyConnection..ExtendedInfo = "CRYPT=RC5_16"
will modify ..CryptMethod.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment