ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
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: This function should only be used by experienced programmers. It is not recommended to temporarily disable replication and make changes to the data files. Indeed, problems may occur during the synchronization.
Example
WINDEVUser code (UMC)HFSQL ClassicHFSQL Client/Server
// Désactive la réplication journalée
HSetReplication(False)
// Ajout d'une valeur qui ne sera pas répliquée
HAdd(Client)
// Réactive la réplication journalée
HSetReplication(True)
// Branche la réplication universelle
HSetReplication(rplReplicationUniversal)
Syntax
WINDEVUser code (UMC)HFSQL ClassicHyper File 5.5

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 after replication has been temporarily disconnected will not be updated or created when replication is reactivated.

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):
rplReplicationDisabledReplication was not supported before HSetReplication was called.
rplReplicationLoggedLog-based replication between HFSQL data files was enabled before the call to HSetReplication.
rplReplicationUniversalThe replication performed before calling HSetReplication was a universal replication (between HFSQL data files and data files handled by a Native Connector, for example).
Note: for compatibility with previous versions, the constant rplReplicationHeterogeneous can be used.
<Management mode>: Integer constant
New mode to use:
rplReplicationDisabledTemporarily disables replication.
rplReplicationLoggedAllows you to perform a log-based replication between HFSQL data files (uses the HFSQL data files with logs).
rplReplicationUniversalUsed to perform a universal replication (between an HFSQL database and an Oracle database for example).
Note: for compatibility with previous versions, the constant rplReplicationHeterogeneous can be used.
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 after replication has been temporarily disconnected will not be updated or created when replication is reactivated.
Business / UI classification: Business Logic
Component: wd300rpl.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help