PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • When should I use HBuildKeyValueANSI?
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.
HBuildKeyValueANSI must not be used to:
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
WINDEVWINDEV MobileUniversal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
WINDEVWINDEV MobileUniversal Windows 10 App This function is now available in Windows Store apps mode.
WINDEVWINDEV MobileUniversal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
WINDEVWINDEV MobileUniversal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
WINDEVWINDEV MobileUniversal Windows 10 App This function is now available in Universal Windows 10 App mode.
WINDEVWINDEV MobileUniversal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: 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(<File Name> , <Name of Composite Key> , <Value of Components>)
<Result>: Character string
Value of the composite key that must be saved in the data file.
<File Name>: Character string (with or without quotes)
Name of HFSQL data file used.
<Name of 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 has the following format <Component 1> , <Component 2>, ..., <Component N>.
For example: "MOORE", "Vince".
Remarks
WINDEV MobileWindows MobileHFSQL

When should I use HBuildKeyValueANSI?

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)
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Linux wd230hf.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment