Compression (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | French

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Compression (Property)

In french: Compression

Available only with this kind of connection

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

Find out whether the connection transmits compressed data.
Define whether the data transmitted between the server and the client must be compressed. In this case, if the connection is currently opened, it will be closed and reopened with the new parameters during the first access to a file that uses this connection.

Reminder: The compression of data is used to reduce the volume of data flowing through the transmission media (this feature is interesting for the transmissions invoiced according to the volume of data transmitted). The data compression is supported from version 14 of the HFSQL server. See Compressing frames for more details.

Remark: The connection can correspond to:

a connection described in the data model editor,
a connection described by HConnect, HDescribeConnection or HOpenConnection.
a connection described by a Connection variable.

Versions 18 and later

This property is now available in Windows Store apps mode.

New in version 18

This property is now available in Windows Store apps mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

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

Finding out whether the connection transmits compressed data Hide the details

<Result> = <Connection>..Compression

<Result>: Boolean

True if the transmitted data is compressed,
False if the transmitted data is not compressed.
Remark: The management of compression is available from version 14 of the HFSQL server.

<Connection>: Character string (with or without quotes) or Connection variable

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

Defining the data compression for a connection Hide the details

<Connection>..Compression = <Data compression>

<Connection>: Character string (with or without quotes) or Connection variable

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

<Data compression>: Boolean

True to compress the data,
False not to compress the data.
Remark: The management of compression is available from version 14 of the HFSQL server.