Compares two values by sorting them according to the specified HFSQL index item: all the sort options specified for the item are taken into account (sensitivity to the case, to the punctuation, sort direction, Unicode language, ...).
SWITCH HCompareItem(Customer, Name, sName1, sName2)
CASE 0
Info("The two values are identical.")
CASE 1
Info("Name1 is bigger.")
CASE -1
Info("Name2 is bigger.")
END
HCompareItem(MyTestFile, ItmCaseSensitiveAscending, "A", "B")
// Returns -1 (like StringCompare)
HCompareItem(MyTestFile, ItmCaseInsensitiveAscending, "A", "B")
// Returns +1 (unlike StringCompare)
Syntax
<Result> = HCompareItem(<Data file> , <Sort item> , <Value 1> , <Value 2>)
<Result>: Integer
- 0 if the values are equal.
- -1 if the first value is less than the second one.
- 1 if the first value is greater than the second one.
<Data file>: Character string
Name of the HFSQL data file containing the index that describes the sort.
<Sort item>: Character string
Name of the item corresponding to the sort index.
<Value 1>: Type of value
First value to compare.
<Value 2>: Type of value
Second value to compare.