ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

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
<Source>.MigrateLinkedCompositeKey (Function)
In french: <Source>.MigreClé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. <Source>.MigrateLinkedCompositeKey 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 <Source>.MigrateLinkedCompositeKey, the values of the new records may be corrupted.
Example
// Modify the values of Orders.CustomerCompKey
Customer.MigrateLinkedCompositeKey(CompKey, Orders, CustomerCompKey)
Syntax
<Result> = <Source>.MigrateLinkedCompositeKey(<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.
<Source>: Type corresponding to the specified source
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 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 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/08/2025

Send a report | Local help