Converts a numeric value into a binary string in order to perform a search on a numeric key.
// 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 the conversion depends on the type of the variable passed as parameter.
- Convert must be used to perform searches on a numeric composite key in an 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