HBuildKeyValueANSI (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

When to use HBuildKeyValueANSI?

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL functions

HBuildKeyValueANSI (Function)

In french: HConstruitValCléANSI

Available only with these kinds of connection

Regardless of the platform used, the data stored in the HFSQL data files is in ANSI format.

On a Unicode platform, the function HBuildKeyValueANSI function constructs the value of a compound key and records it in an HFSQL data file.

On an ANSI platform, this function is equivalent to HBuildKeyValue.

HBuildKeyValueANSI must not be used to:

implement a filter (HFilter) on a composite key.
perform a search (HReadSeekFirst, HReadSeekLast, etc.) on a composite key.

For the filters or searches, use HBuildKeyValue.

Reminder Compound keys are binary strings whose contents cannot be displayed directly. For more details, see Composite keys.

Example

// Affectation d'une rubrique dans un fichier de données lié
Facture.NomClientPrénom = HBuildKeyValueANSI(Client, ...
	NomClientPrénom, Client.Nom, Client.Prénom)

Syntax

<Result> = HBuildKeyValueANSI(<Data file> , <Composite key> , <Value of components>)

<Result>: Character string

Value of the composite key to be stored in the data file.

<Data file>: Character string

Name of the HFSQL data file used.

<Composite key>: Character string

Name of the item corresponding to the composite key.

<Value of components>: Character string

Value that will be assigned to each component of the composite key.
This parameter has the following format: <Component 1> , <Component 2>, ...,<Component N>.
For example: "MOULIN", "Françoise".

Remarks

When to use HBuildKeyValueANSI?

HBuildKeyValueANSI can be used to store the value of a composite key used as a link key in a data file.

Example:

To record a new invoice on a Unicode platform, use the following code:

Facture.NumFacture = ... 
...
Facture.NomClientPrénom = HBuildKeyValueANSI(Client, ...
	NomClientPrénom, Client.Nom, Client.Prénom)
...
HAdd(Facture)

Business / UI classification: Business Logic

Component: wd300hf.dll