ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
  • ExtendedInfo property and connection
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Encryption (Property)
In french: Cryptage
ODBCHFSQL ClassicNot available with these kinds of connection
Warning
From version 28 (75), CryptMethod is kept for backward compatibility. This property is replaced by Encryption.
The Encryption property allows you to manage the type of encryption used between Client computers and an HFSQL server. You can:
  • Find out the type of encryption used for an HFSQL Client/Server connection.
  • Define the type of encryption used for the HFSQL Client/Server connection. In this case, if the connection is currently open, it will be closed and opened again with the new parameters when first accessing a data file that uses this connection.
Remark: The connection can correspond to:
Example
MyConnection is Connection
// Describe the connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER"
MyConnection.Database = "Database"
MyConnection.Encryption = hEncryptionRC5_16
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
 
HOpenConnection(MyConnection)
Syntax

Finding out the type of encryption for an HFSQL Client/Server connection Hide the details

<Type of encryption> = <Connection used>.Encryption
<Type of encryption>: Constant
Returns the type of encryption used for the connection:
New in version 28
hEncryptionAES128
The connection between the server and the client computers is encrypted using a 128-bit AES encryption algorithm with the OFB mode of operation.
New in version 28
hEncryptionAES192
The connection between the server and the client computers is encrypted using a 192-bit AES encryption algorithm with the OFB mode of operation.
New in version 28
hEncryptionAES256
The connection between the server and the client computers is encrypted using a 256-bit AES encryption algorithm with the OFB mode of operation.
hEncryptionNONo encryption is performed.
hEncryptionRC5_16The connection between the server and the client computers is encrypted using an optimized 16-round RC5 encryption algorithm (128 bits).
hEncryptionStandardThe connection between the server and the client computers is encrypted using an optimized 128-bit encryption algorithm
<Connection used>: Connection name
Name of the connection used. This name is defined:

Defining the type of encryption for a connection Hide the details

<Connection used>.Encryption = <Type of encryption>
<Connection used>: Connection name
Name of the connection used. This name is defined:
<Type of encryption>: Constant
Defines the type of encryption used for the connection:
New in version 28
hEncryptionAES128
The connection between the server and the client computers is encrypted using a 128-bit AES encryption algorithm with the OFB mode of operation.
New in version 28
hEncryptionAES192
The connection between the server and the client computers is encrypted using a 192-bit AES encryption algorithm with the OFB mode of operation.
New in version 28
hEncryptionAES256
The connection between the server and the client computers is encrypted using a 256-bit AES encryption algorithm with the OFB mode of operation.
hEncryptionNONo encryption is performed.
hEncryptionRC5_16The connection between the server and the client computers is encrypted using an optimized 16-round RC5 encryption algorithm (128 bits).
hEncryptionStandardThe connection between the server and the client computers is encrypted using an optimized 128-bit encryption algorithm.
Remarks
WINDEVWEBDEV - Server codeReports and QueriesUniversal Windows 10 AppiPhone/iPadIOS WidgetUser code (UMC)AjaxHFSQL Client/Server

ExtendedInfo property and connection

Changing the encryption information of an HFSQL Client/Server connection with the ExtendedInfo property automatically updates the information returned by the Encryption property (and vice versa).
Therefore, the following line of code:
MyConnection.CryptMethod = hEncryptionRC5_16
will modify the ENCRYPTION option in the string of extended information.
Similarly, the following line of code:
MyConnection.ExtendedInfo = "CRYPT=RC5_16"
will modify the Encryption property.
See also
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/28/2023

Send a report | Local help