HInitSubscriber (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

Range of identifiers
Replication and log process

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HInitSubscriber (Function)

In french: HInitAbonné

Available 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:

automatically, when creating a data file (HCreation, HCreationIfNotFound).
manually, by HInitSubscriber.

HInitSubscriber must be called only when the data files are installed on the subscriber.

Caution: Data files must be opened before using HInitSubscriber.

Example

// Initialise la plage d'ID Auto du fichier de données Client
HInitSubscriber("Client", "C:\DATA\Replic\AbonneParis.rpl")

// Initialise la plage d'ID Auto de tous les fichiers de données
HInitSubscriber("*", "C:\DATA\Replic\AbonneParis.rpl")

Syntax

<Result> = HInitSubscriber(<Data file> , <Subscriber Replica>)

<Result>: Boolean

True if the initialization was performed,
False if an error occurs. 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:

when creating a data file (HCreation, HCreationIfNotFound).
via WDReplic.
when HInitSubscriber is used.

The range of identifiers is returned by MinAutoID and MaxAutoID.

For more details, see the consequences of implementing the replication.

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 replication is based on log files and tables of operations in data files. Log-based replication does not work if the location of the logs and operation tables is invalid.

Component: wd300rpl.dll