PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
HRplDeclareLink (Function)
In french: HRplDéclareLiaison
ODBCOLE DBNot available with these kinds of connection
Declares a (1,1) (0,n) link between two tables. Only the records found in the target table with a corresponding record in the source table (while respecting the filter of this one) will be replicated during a universal replication.
Note: This function can be used during the universal replication only. Note: The replication is not available when accessing a database via Remote access. Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
WEBDEV - Server codeLinux This function is now available for the Linux WEBDEV sites.
New in version 21
WEBDEV - Server codeLinux This function is now available for the Linux WEBDEV sites.
WEBDEV - Server codeLinux This function is now available for the Linux WEBDEV sites.
Example
// Retrieve a subscriber as well as his messages
HCreateSubscriberReplica("", "", "Mr X", 0, "Messages" + CR + "Recipients")
// Filter the messages
HFilter(Recipients, Name, "X")
// Declare the link
HRplDeclareLink(Recipients, Messages, MessagesID, MessagesID)
HCreateMoveableReplica("", "", rplToSubscriber)
Syntax
<Result> = HRplDeclareLink(<Name of Source File> , <Name of Source Item> , <Name of Target File> , <Name of Target Item>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred (the specified tables and items do not exist for example). HError is used to identify the error. Caution: <Result> is set to True even if the specified files/tables are not replicated.
<Name of Source File>: Character string (with or without quotes)
Name of the file or table whose multiplicity is set to (1, 1).
<Name of Source Item>: Character string (with or without quotes)
Name of the item affected by the link in the source file.
<Name of Target File>: Character string (with or without quotes)
Name of the file or table whose multiplicity is set to (0, n).
<Name of Target Item>: Character string (with or without quotes)
Name of the item affected by the link in the target file.
Remarks
  • The operation is taken into account only if the source table/file is specified AFTER the target table/file in the list of tables passed to HCreateSubscriberReplica.
  • The filtering performed on the second file/table is not respected.
  • As soon as a file is target of a declared link, this file is replicated via this link only.
  • If a file is the source of two links, a record will be replicated if it belongs to one of the links.
Component : wd250rpl.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment