ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HMigrateLinkedCompositeKey (Function)
In french: HMigreCléComposéeReliée
HFSQL ClassicAvailable 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 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:
  • 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. If records are added between the migration and the call to HMigrateLinkedCompositeKey, the values of the new records may be corrupted.
Example
// Modify the values of ORDERS.CUSTOMERCOMPKEY
HMigrateLinkedCompositeKey(CUSTOMER, COMPKEY, ORDERS, CUSTOMERCOMPKEY)
Syntax
<Result> = HMigrateLinkedCompositeKey(<Link source file> , <Source composite key> , <Linked 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 file>: Character string
Name of the source file for the link, containing the description of the composite key.
<Source composite key>: Character string
Name of the "Composite key" item used in the source file of the link.
<Linked file>: Character string
Name of the linked file containing the value of the composite key to migrate
<Linked key>: Character string
Name of the key item in the linked 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: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help