PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

This content comes from an automatic translation.
  • When to use the HBuildKeyValueANSI function?
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HBuildKeyValueANSI (Function)
In french: HConstruitValCléANSI
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Regardless of the platform used, the data saved in the HFSQL files is in ANSI format.
On a UNICODE platform (Pocket PC for example), HBuildKeyValueANSI is used to build the value of a composite key in order to save this composite key in a HFSQL Mobile data file.
On an ANSI platform (PC for example), this function is equivalent to HBuildKeyValue.
LThe HBuildKeyValueANSI function must not be used for:
For the filters or searches, use HBuildKeyValue.
Reminder: The composite keys are binary strings whose content cannot be displayed directly. See Composite keys for more details.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Assign an item to a linked file
Invoice.CustLastNameFirstName = HBuildKeyValueANSI(Customer, ...
CustLastNameFirstName, Customer.LastName, Customer.FirstName)
Syntax
<Result> = HBuildKeyValueANSI(<Data file> , <Composite key> , <Value of components>)
<Result>: Character string
Value of the composite key that must be saved in the data file.
<Data file>: Character string (with or without quotes)
Name of HFSQL data file used.
<Composite key>: Character string (with or without quotes)
Name of the item corresponding to the composite key.
<Value of components>: Character string (with quotes)
Value that will be assigned to each component of the composite key.
This parameter is of the form <Component 1>, <Component 2>, ...,<Component N>.
For example: "MOORE", "Vince".
Remarks
HFSQL

When to use the HBuildKeyValueANSI function?

HBuildKeyValueANSI must be used to save the value of a composite key used a link key in a data file.
Example:
The following code is used to save a new invoice on a UNICODE platform (Pocket PC for example):
Invoice.InvoiceNum = ...
...
Invoice.CustLastNameFirstName = HBuildKeyValueANSI(Customer, ...
CustLastNameFirstName, Customer.LastName, Customer.FirstName)
...
HAdd(Invoice)
Business / GUI classification : Business Logic
Component : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment