Compression (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage properties / HFSQL properties

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Compression (Property)

In french: Compression

Available only with this kind of connection

The Compression property is used to manage data compression during a connection (HFSQL Client/Server, etc.). You can:

Determine whether the connection sends compressed data.
Define whether the data transferred between the server and the client should be compressed. In this case, when you open a file that uses an open connection, that connection will be closed and reopened with the new parameters.

Reminder: Data compression reduces the volume of data being transferred (which can be an advantage for volume-based billing). Data compression is supported from HFSQL server version 14. For more details, see Compressing frames.

Remark: The connection can correspond to:

a connection defined in the data model editor,
a connection defined with HConnect, HDescribeConnection or HOpenConnection.
a connection defined with a variable of type Connection.

Example

MyConnection is Connection
// Describe the connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER" 
MyConnection.Database = "Test"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor
MyConnection.Compression = True

HOpenConnection(MyConnection)

Syntax

Determining whether the connection sends compressed data Hide the details

<Result> = <Connection>.Compression

<Result>: Boolean

True if transmitted data is compressed,
False if transmitted data is not compressed.
Remark: Data compression is supported from HFSQL server version 14.

<Connection>: Character string or Connection variable

Name of the connection used. This name is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with the Connection type.

Defining data compression for a connection Hide the details

<Connection>.Compression = <Data compression>

<Connection>: Character string or Connection variable

Name of the connection used. This name is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with the Connection type.

<Data compression>: Boolean

True to compress the data,
False not to compress the data.
Remark: Data compression is supported from HFSQL server version 14.