ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HMigrateLinkedCompositeKey (Function)
In french: HMigreCléComposéeReliée
HFSQL ClassicAvailable only with this kind of connection
Migrates linked compound key values from a data file in Hyper File 5.5 format to 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 linked keys corresponding to a compound key is no longer correct after migration of data files from Hyper File 5.5 format to HFSQL Classic format. HMigrateLinkedCompositeKey changes the value of the linked keys and retrieves the value of the composite key in the linked key.
Use conditions
This function must be used:
  • only with data files in HFSQL Classic format (data files in 5.5 format migrated to Classic format),
  • once for each key to migrate,
  • just after the migration from Hyper File 5.5 to HFSQL Classic. If records are added between the migration and the call to HMigrateLinkedCompositeKey, the values of the new records may be corrupted.
Example
// Modifier les valeurs de la clé COMMANDE.CLECOMPCLIENT
HMigrateLinkedCompositeKey(CLIENT, CLECOMP, COMMANDE, CLECOMPCLIENT)
Syntax
<Result> = HMigrateLinkedCompositeKey(<Link source data file> , <Source composite key> , <Linked data file> , <Linked key> [, <Progress Bar>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError returns more details about the problem.
<Link source data file>: Character string
Name of the source data file for the binding, containing the description of the compound key.
<Source composite key>: Character string
Name of the "Compound Key" field in the link source data file.
<Linked data file>: Character string
Name of the linked data file containing the value of the compound key to be migrated.
<Linked key>: Character string
Name of the key field in the linked data file. The value of this item must be migrated.
<Progress Bar>: Optional window or control name
Name of Progress Bar control or name of window used to show the migration progress.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help