HMigrateLinkedCompositeKey (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HMigrateLinkedCompositeKey

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HMigrateLinkedCompositeKey (Function)

In french: HMigreCléComposéeReliée

Available 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.

Remark: 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(<Link source file> , <Source composite key> , <Linked file> , <Linked key> [, <Progress Bar>])

<Result>: Boolean

True if the operation was performed,
False if a problem occurred. HError returns more details about the problem.

<Link source file>: Character string (with or without quotes)

Name of the source file for the link, containing the description of the composite key.

<Source composite key>: Character string (with or without quotes)

Name of the "Composite key" item used in the source file of the link.

<Linked file>: Character string (with or without quotes)

Name of the linked file containing the value of the composite key to migrate

<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 window or control name

Name of Progress Bar control or name of window used to show the migration progress.

Component : wd250hf.dll