PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

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
HInfoReplica (Function)
In French: HInfoRéplica
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Returns information about the specified replica. This function is used to find out whether the database contains data to replicate.
Caution: This function cannot be used with the universal replication. This function can be used with the "logged replication" only.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Gray the button if there is no data to synchronize
IF HInfoRéplica("", rplMasterIsUpToDate) = True THEN
        BTN_SYNCHRO..State = Grayed
END
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)HFSQLHFSQL Client/ServerHyper File 5.5
// If the master was not synchronized for more than 7 days
IF HInfoReplica("", rplMasterIsUpToDate, "PARIS") = False THEN
NbDays is int
NbDays = HInfoReplica("", rplDateSynchroToMaster, "PARIS")/(24*60*60)
IF NbDays > 7 THEN
 Info("PARIS was not updated since " + ...
NbDays + " days.")
END
END
Syntax
<Result> = HInfoReplica(<Full Path of Replica File> , <Sought Information> [, <Identifier of Subscriber Replica>])
<Result>: Type depending on the type of information
Requested information.
<Full Path of Replica File>: Character string (with quotes)
Full path of the replica file (".RPL" or ".RPM" file) corresponding to the replica to analyze. For a movable replica, corresponds to the path of the "*.WDZ" file.
If this parameter corresponds to an empty string (""), the replica is sought in the current directory.
<Sought Information>: Constant
The information differs according to the type of replica:
  • Master replica:
    rplSubscriberIsUpToDate<Result> is a boolean.
    • True if no data must be sent,
    • False if data must be sent to a subscriber computer.
    rplDateSynchroFromSubscriber<Result> is a character string in "YYYYMMDD" format.
    Date of the last synchronization toward the master database.
    rplDateSynchroToSubscriber<Result> is a character string in "YYYYMMDD" format.
    Date of the last synchronization toward the subscriber database.
    rplNumMoveableReplicaGeneration number of the last movable replica generated for the subscriber replica whose identifier is <Identifier of Subscriber Replica>.
  • Subscriber replica:
    rplDateSynchroFromMaster<Result> is a character string in "YYYYMMDD" format.
    Date of the last synchronization from the master database.
    rplDateSynchroToMaster<Result> is a character string in "YYYYMMDD" format.
    Date of the last synchronization toward the master database.
    rplMasterIsUpToDate<Result> is a boolean.
    • True if no data must be sent,
    • False if data must be sent to a master computer.
    rplNumMoveableReplicaGeneration number of the last movable replica that was generated. This number is incremented whenever HCreateMoveableReplica is called.
  • Movable replica:
    rplNumMoveableReplicaGeneration number of the last movable replica that was generated. This number is incremented whenever HCreateMoveableReplica is called.
<Identifier of Subscriber Replica>: Optional character string or optional integer
Identifies a subscriber replica. This parameter is taken into account if <Full Path of Replica File> corresponds to a master replica. This parameter can be:
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment