AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
HMigrateLinkedCompositeKey (Function)
HFSQL ClassicDisponible solo con este tipo de conexión
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.
Ejemplo
// Modify the values of ORDERS.CUSTOMERCOMPKEY
HMigrateLinkedCompositeKey(CUSTOMER, COMPKEY, ORDERS, CUSTOMERCOMPKEY)
Sintaxis
<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.
Componente: wd300hf.dll
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 10/01/2025

Señalar un error o enviar una sugerencia | Ayuda local