PC SOFT

WINDEV, WEBDEV 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
HMigrateLinkedCompositeKey (Function)
In french: HMigreCléComposéeReliée
HFSQLAvailable only with this kind of connection
Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format.
When should I use this function?
The format of composite keys changed between Hyper File 5.5 and HFSQL Classic (single-user or multi-user).
Consequence: the value of the linked keys corresponding to a composite key is incorrect once the files have been migrated from Hyper File 5.5 to HFSQL Classic. HMigrateLinkedCompositeKey is used to modify the value of the linked keys and to retrieve the value of the composite key in the linked key.
Use conditions:
This function must be used:
  • with files in HFSQL Classic format (files in 5.5 format migrated to the Classic format),
  • once for each key to migrate
  • just after the migration from Hyper File 5.5 to HFSQL Classic. In fact, if records are added between the migration and the call to HMigrateLinkedCompositeKey, the values of the new records may be corrupted.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Modify the values of ORDERS.CUSTOMERCOMPKEY
HMigrateLinkedCompositeKey(CUSTOMER, COMPKEY, ORDERS, CUSTOMERCOMPKEY)
Syntax
<Result> = HMigrateLinkedCompositeKey(<Name of source file for link> , <Name of source composite key> , <Name of linked file> , <Name of linked key> [, <Progress Bar>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError returns more details about the problem.
<Name of source file for link>: Character string (with or without quotes)
Name of the source file for the link, containing the description of the composite key.
<Name of source composite key>: Character string (with or without quotes)
Name of the "Composite key" item used in the source file of the link.
<Name of linked file>: Character string (with or without quotes)
Name of the linked file containing the value of the composite key to migrate
<Name of linked key>: Character string (with or without quotes)
Name of the key item in the linked file. The value of this item must be migrated.
<Progress Bar>: Optional character string (with or without quotes)
Name of window where the progress bar will be displayed or name of Progress Bar control.
Component : wd240hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment