ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Range of identifiers
  • Replication and log process
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
HInitSubscriber (Function)
In french: HInitAbonné
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension). This function can be used with log-based replication only.
The range of automatic identifiers is initialized:
HInitSubscriber must be called only when the data files are installed on the subscriber.
Caution: The data files must be opened before using HInitSubscriber.
Example
// Initialize range of auto IDs for the Customer data file
HInitSubscriber("Customer", "C:\DATA\Replic\ParisSubscriber.RPL")
 
// Initialize range of auto IDs for all data files
HInitSubscriber("*", "C:\DATA\Replic\ParisSubscriber.RPL")
Syntax
<Result> = HInitSubscriber(<Data file> , <Subscriber Replica>)
<Result>: Boolean
  • True if the initialization was performed,
  • False if an error occurred. HErrorInfo is used to identify the error.
<Data file>: Character string
Name of HFSQL data file to use.
If this parameter is equal to "*", the ranges of identifiers will be initialized for all the data files described as "replicated" in the analysis.
<Subscriber Replica>: Character string
Name and full path of subscriber replica. This parameter can correspond to a UNC path.
Remarks

Range of identifiers

The automatic identifiers for the files of subscriber replicas are using a range of identifiers that differs from the one used by the file of master replica and by the other files of subscriber replicas.
This range of automatic identifiers is written in the header of each data file (".FIC" extension).
This range is initialized:
The range of identifiers is returned by MinAutoID and MaxAutoID.

Replication and log process

If HInitSubscriber is used, the location of logs and operation tables must also be initialized (HChangeLogDir, LogDirectory and OperationLogDirectory).
Reminder: Log-based replication uses logs and operation tables of data files. Log-based replication does not work if the location of the logs and operation tables is invalid.
Component: wd290rpl.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help