PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Properties specific to the description of hRSConfig variables
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
The hRSConfig type is used to define the advanced characteristics of a replication between 2 HFSQL servers. The characteristics of this replication can be defined and modified by several WLanguage properties.
Note: See Declaring a variable for more details.
Example
ConfigReplication1 is hRSConfig
ConfigReplication1..Server = "atlas.mycompany.com:4996"
Add(ConfigReplication1..File, "MyDatabase")
Add(ConfigReplication1..File, "-MyDatabase\MyFile.fic")
HRSAddConfig(Cnt, ConfigReplication1, False)
ConfigReplication1 is hRSConfig
ConfigReplication1..Server = "atlas.mycompany.com:4996"
Add(ConfigReplication1..File, "MyDatabase")
Add(ConfigReplication1..File, "-MyDatabase\MyFile.fic")
HRSAddConfig(Cnt, ConfigReplication1, hrsNoCopy)
Remarks

Properties specific to the description of hRSConfig variables

The following properties can be used to handle a replication between HFSQL servers:
Property nameType usedEffect
BidirectionalBoolean
  • True if the replication must be performed in both directions: the replication will be bidirectional.
  • False otherwise (default value): the replication will be unidirectional.
DescriptionCharacter stringDescription of replication.
FileArray of stringsList of elements to replicate.
The elements to replicate can correspond to:
  • a database,
  • a data file,
  • a data file to exclude from the replication. In this case, the name of the file must be prefixed by "-" (minus).
IdentifierIntegerUsed to identify the replication handled.
This property is available in read-only.
Versions 22 and later
Initialization
New in version 22
Initialization
Initialization
IntegerUsed to follow the evolution of the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server) during a copy in background task (HRSAddConfig associated with the hrsCopyBackgroundTask constant).
If this property:
  • is included between 0 and 1000, the replication is currently added.
  • is set to 1000, the replication was added.
  • is not specified, the replication failed to be added.
This property is available in read-only.
PasswordCharacter stringPassword specific to the replication. This password must correspond to the password specified in HRSInit used on the subscriber server.
This property is available in write mode.
SchedulinghScheduling variableReplication period.
If all the members of the hScheduling variable are left empty, it will be a replication in streaming.
ProcedureForModificationConflictResolutionCharacter stringName of the stored procedure to use if the method for solving conflicts (..ModificationConflictResolution) corresponds to the hmcrProcedureWithModifiedItems constant or to the hmcrProcedureAllItems constant.
This stored procedure must return:
  • the opRetry constant to validate the replication of the modification,
  • the opCancel constant to cancel the replication of the modification.
This stored procedure must be found in the replicated database on the subscriber server.
ModificationConflictResolutionInteger constantMethod for solving conflicts:
  • hmcrHigherPriority (default value): During a conflict, only the priority value defined for the server is taken into account. The smaller the priority value defined for the server is, the higher the priority granted to the server will be.
  • hmcrMoreRecent: During a conflict, the more recent element has priority.
    Caution: This method requires a synchronization of the clock on the different servers.
  • hmcrProcedureWithModifiedItems: During a conflict, a stored procedure (defined by ..ProcedureForModificationConflictResolution) is started. In this procedure, only the modified items will be accessible.
  • hmcrProcedureAllItems: During a conflict, a stored procedure (defined by ..ProcedureForModificationConflictResolution) is started. In this procedure, all the items found in the record will be accessible.
ServerCharacter stringServer toward which the replication will be performed. This server is identified by:
  • its DNS name or its IP address.
  • the replication port (4996 by default).
If the port differs from the default port, the following syntax must be used to specify it: "<Server Name>:<Replication Port>". This port must correspond to the port specified in HRSInit used on the subscriber server.
Note: These properties can be used with one of the following syntaxes:
  • <Variable Name>..<Property Name>
  • <Variable Name>.<Property Name>
Minimum required version
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment