PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
Convert (Function)
In french: Convert
Converts a numeric value into a binary string in order to perform a search on a numeric key.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Windows Store apps mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 21 and later
Apple Watch This function is now available in Apple Watch mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Apple Watch This function is now available in Apple Watch mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Apple Watch This function is now available in Apple Watch mode.
Universal 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
// CompKey is made of PRODREF (text) and QTY (integer)
// EDT_Quantity and EDT_ProductRef are two edit controls
Srch is string
Srch = Complete(EDT_ProductRef, 8) + Convert(EDT_Quantity)
HReadSeek(Orders, CompKey, Srch)
Syntax
<Result> = Convert(<Numeric value>)
<Result>: Character string
Conversion result. This result is the binary string corresponding to the value of numeric variable. This binary string cannot be directly displayed. This binary string is only used to perform searches in the HFSQL data file.
<Numeric value>: Numeric variable
Name of numeric variable to convert
Remarks
  • The type of conversion depends on the type of variable passed in parameter.
  • The must be used to perform searches on a numeric composite key in a HFSQL data file. For the simple numeric keys, there is no need to convert the numeric value into binary string, the conversion is automatically performed.
  • Convert cannot be used in external language. You must use HConvertX.
  • HConvertX and Convert perform the same action. With Convert (unlike HConvertX), there is no need to specify the type of value to convert ; the type is automatically deduced from the type of <Numeric_Value> variable
Component : wd240vm.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment