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.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
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
Windows MobileHFSQL

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