HCompareItem (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

This content comes from an automatic translation.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Functions for HFSQL management

HCompareItem (Function)

In french: HCompareRubrique

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, ...).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Versions 22 and later

This function is now available for the Java applications.

New in version 22

This function is now available for the Java applications.

Example

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> , <Sorting field> , <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 (with or without quotes)

Name of the HFSQL data file containing the index that describes the sort.

<Sorting field>: Character string (with or without quotes)

Name of the item corresponding to the sort index.

<Value 1>: Type of the value

First value to compare.

<Value 2>: Type of the value

Second value to compare.

Component : wd250hf.dll