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
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
Temporarily disables (or re-enables) the replication. Replication can be a log-based replication or a universal replication.
The replication between HFSQL data files is automatically managed.
When the replication is "disabled", you have the ability to access the HFSQL Classic data files without storing the information required by the replication. Then, the replication management must be restored.
Caution: The use of this function is reserved to experienced programmers. We do not advise you to temporarily disable the management of replication and perform modifications on the data files. Indeed, problems may occur during the synchronization.
Universal Windows 10 AppAndroidAndroid Widget iPhone/iPadIOS WidgetMac Catalyst Only universal replication is available (syntax 2).
Example
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)AjaxHFSQL 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
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)AjaxHFSQL ClassicHyper File 5.5

Managing 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 management of replication,
  • True to re-enable the management of replication.
Caution: Records added or modified after replication has been temporarily disconnected will not be updated or created when replication is reactivated.

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

<Result> = HSetReplication(<Management mode>)
<Result>: Integer constant
Former management mode of replication (before the modification):
rplReplicationDisabledReplication was not supported before HSetReplication was called.
rplReplicationLoggedLog-based replication between HFSQL data files was managed 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).
Remark: the rplReplicationHeterogeneous constant can be used for backward compatibility with the earlier versions.
<Management mode>: Integer constant
New management mode to use:
rplReplicationDisabledUsed to temporarily disable the management of 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).
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 after replication has been temporarily disconnected will not be updated or created when replication is reactivated.
Business / UI classification: Business Logic
Component: wd290rpl.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 10/17/2023

Send a report | Local help