HCompareItem (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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 in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for 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> , <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 (with or without quotes)

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

<Sort item>: Character string (with or without quotes)

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.

Component: wd260hf.dll