HCreateSubscriberReplica (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HCreateSubscriberReplica

Presentation

Example

Logged replication: Directory for creating the files required by the replication and by the log process

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Logged replication: Directory for creating the files required by the replication and by the log process

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HCreateSubscriberReplica (Function)

In french: HCréeRéplicaAbonné

Available only with these kinds of connection

Creates the description file of a subscriber replica. The extension of the file corresponding to the subscriber replica is .RPL.

This function can be used with the logged replication and/or with the universal replication

Caution: When creating a subscriber replica, you must:

have created the master replica (HCreateMasterReplica).
have access to the master replica.

Remark: The replication is not available when accessing a database via Remote access.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

New in version 22

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

Example

// Create the master replica file in the C:\RPL\France directory
// while specifying a file name
HCreateMasterReplica("C:\RPL\France\ReplicaFrance.RPM")
// Create the subscriber replica
HCreateSubscriberReplica("C:\RPL\France\", "C:\RPL\USA", 1)

Syntax

Universal replication Hide the details

<Result> = HCreateSubscriberReplica(<Directory of master replica> , <Directory of subscriber replica> , <Identifier> , <Size of range of identifiers> , <List of tables to replicate>)

<Result>: Integer

Identifier of Subscriber Replica that was created,
0 if no subscriber replica was created.

<Directory of master replica>: Character string (with quotes)

Directory where the description file of Master Replica (RPM file) was created (HCreateMasterReplica). This directory can be a network directory or a UNC path.
If this parameter corresponds to an empty string (""), the description file will be sought in the current directory of HFSQL data files (defined in the data model editor or by programming).
Caution: This directory must be accessible when running HCreateSubscriberReplica.

<Directory of subscriber replica>: Character string (with quotes)

Directory where the description file of Subscriber Replica must be created. This file is named Replica_<Identifier>.RPL.
If this parameter corresponds to an empty string (""), the description file will be created in the current directory of HFSQL data files (defined in the data model editor or by programming).

<Identifier>: Integer or character string

Identifier of the subscriber replica. This identifier will be used by HCreateMoveableReplica.
A WLanguage error occurs if the specified identifier already exists.

<Size of range of identifiers>: Integer

This parameter is ignored.

<List of tables to replicate>: Character string

This list has the following format:

<TableName>[+TAB+<NameDateItem>][+<CR>+<TableName>[+TAB+<NameDateItem>]]...

Caution: The order of the tables is important. The order of the tables is the order of the dependencies for the tables.
If the records of file 1 are linked to the records of file 2 and if the record must be found in file 2 in order for the addition in file 1 to comply with the integrity rules, then file 1 must be positioned first in the list.
For example, for the "Customer", "Orders" and "Order line" files (that are linked by links whose cardinalities are (0,n) - (1,1)), the "Customer" file must be positioned first (a customer must exist to add an order), then the "Orders" file (an order must exist to add an order line) and finally the "Order line" file.
The name of Date item is mandatory for the databases not in HFSQL format. This item must correspond to an item of the data file updated during an addition or during a modification. This operation must be performed by the application.

Logged replication (between HFSQL databases) Hide the details

<Result> = HCreateSubscriberReplica(<Directory of master replica> , <Directory of subscriber replica> [, <Identifier> [, <Size of range of identifiers>]])

<Result>: Integer

Identifier of Subscriber Replica that was created,
0 if no subscriber replica was created.

<Directory of master replica>: Character string (with quotes)

Directory where the description file of Master Replica (RPM file) was created (HCreateMasterReplica). This directory can be a network directory or a UNC path.
If this parameter corresponds to an empty string (""), the description file will be sought in the current directory of HFSQL data files (defined in the data model editor or by programming).
Caution: this directory must be accessible when running HCreateSubscriberReplica.

<Directory of subscriber replica>: Character string (with quotes)

Directory where the description file of Subscriber Replica must be created. This file is named Replica_<Identifier>.RPL.
If this parameter corresponds to an empty string (""), the description file will be created in the current directory of HFSQL data files (defined in the data model editor or by programming).

<Identifier>: Optional integer or character string

Identifier of the subscriber replica. This identifier will be used by HCreateMoveableReplica.
If this parameter corresponds to an empty string (""), an identifier is automatically returned by the function. A WLanguage error occurs if the specified identifier already exists.

<Size of range of identifiers>: Optional integer

Size of the range of numbers reserved for the automatic identifiers for this replica. These identifiers will be used for all the new records created by this replica. If this parameter is not specified, the size of the range of reserved identifiers is set to 1 billion. If this parameter is set to 0, no range is reserved for the automatic identifiers.

Remarks

Logged replication: Directory for creating the files required by the replication and by the log process

The logged replication is closely linked to the log process. The log process is automatically enabled when the replication is implemented in an application.

For all the files used (data files, log files or replication files), the paths of the corresponding physical files can be defined in the data model editor or by programming.

By default, the tree structure of data files is as follows (example for the SalesMgt application):

The following table presents the default value for these different directories and their configuration mode in the data model editor or by programming.

	Default value	Where to configure it in the data model editor?	How to change the default value by programming?

Directory of data files	Directory of the executable.	For all the data files of the application: "Details" tab of the analysis description For each data file: "Info" tab of the description of the data file.	To modify the default directory for the data files of the application, use HSubstDir. When creating the files for the log process and for the replication, the created directories will be relative to this new directory. Remark: To modify the directory for one of the data files only, use HChangeDir.
Directory of the files for replication	RPL sub-directory of the default directory of the data files.	"Log\Replica" tab of the analysis description.	Specify the requested directory in HCreateMasterReplica and HCreateSubscriberReplica.
Directory of files for log process	JNL sub-directory of the default directory of data files.	For all the data files of the application: "Log\Replica" tab of the analysis description. For each data file: "Various" tab of the description of the data file.	To modify the directory of log files, use HChangeLogDir. This function is used to: change the directory of Log file (JNL file) change the directory of the JNL file and the directory of the files for the log process (JournalIdentification and JournalOpération files).

Caution: To manage the logged replication in an application, the table of the log operations (JournalOpération.fic file) must be identical for all the data files in replication in the same analysis.

Business / UI classification : Business Logic

Component : wd250rpl.dll