HSetReplication (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HSetReplication (Function)

In french: HGèreRéplication

Not available with these kinds of connection

Temporarily disables (or re-enables) the replication. Replication can be a log-based replication or a universal replication.

Replication between HFSQL data files is enabled by default.

When the replication is "disabled", you have the ability to access the HFSQL Classic data files without storing the information required by the replication. It is then necessary to re-enable replication.

Caution: The use of this function is reserved to experienced programmers. It is not recommended to temporarily disable replication and make changes to the data files. Indeed, problems may occur during the synchronization.

Only universal replication is available (syntax 2).

Example

// Disables the log-based replication
HSetReplication(False)
// Add a value that will not be replicated
HAdd(Customer)
// Re-enables the log-based replication
HSetReplication(True)

// Enables the universal replication
HSetReplication(rplReplicationUniversal)

Syntax

Log-based replication between HFSQL databases Hide the details

<Result> = HSetReplication(<Management mode>)

<Result>: Boolean

True if replication was supported before the call to HSetReplication,
False if replication was not supported before using HSetReplication.

<Management mode>: Boolean

False to temporarily disable the replication,
True to re-enable replication.
Caution: Records added or modified while replication is disabled will not be updated or created when replication is re-enabled.

Log-based replication (between HFSQL databases) or universal replication Hide the details

<Result> = HSetReplication(<Management mode>)

<Result>: Integer constant

Old replication mode (before the modification):
rplReplicationDisabled Replication was not supported before HSetReplication was called.
rplReplicationLogged Log-based replication between HFSQL data files was enabled before the call to HSetReplication.
rplReplicationUniversal The replication performed before calling HSetReplication was a universal replication (between HFSQL data files and data files handled by a Native Connector, for example).
Remark: the rplReplicationHeterogeneous constant can be used for backward compatibility with the earlier versions.

<Management mode>: Integer constant

New mode to use:
rplReplicationDisabled Temporarily disables replication.
rplReplicationLogged Allows you to perform a log-based replication between HFSQL data files (uses the HFSQL data files with logs).
rplReplicationUniversal Used to perform a universal replication (between an HFSQL database and an Oracle database for example).
Remark: the rplReplicationHeterogeneous constant can be used for backward compatibility with the earlier versions.

Remarks

The log process is disabled when the replication is disabled. The log process can be re-enabled by HSetLog.
Caution: Records added or modified while replication is disabled will not be updated or created when replication is re-enabled.

Business / UI classification: Business Logic

Component: wd290rpl.dll