Export (0) Print
Expand All

CompareMode Property

Updated: April 2009

Sets and returns the comparison mode for comparing string keys in a Dictionary object.


                      object
                      .CompareMode[ = compare]

object

Required. Always the name of a Dictionary object.

compare

Optional. If provided, compare is a value representing the comparison mode. Acceptable values are 0 (Binary), 1 (Text), 2 (Database). Values greater than 2 can be used to refer to comparisons using specific Locale IDs (LCID).

An error occurs if you try to change the comparison mode of a Dictionary object that already contains data.

The following example illustrates the use of the CompareMode property:

function TestCompareMode(key)
{
    var BinaryCompare = 0, TextCompare = 1;
   
    var d = new ActiveXObject("Scripting.Dictionary");

    // The comparison mode is Text, so the keys are case-insensitive.
    d.CompareMode = TextCompare;

    d.Add("a", "Athens"); 
    d.Add("b", "Belgrade");
    d.Add("c", "Cairo");

    return(d.Item(key));
}
Dim d
Set d = CreateObject("Scripting.Dictionary")

d.CompareMode = vbTextCompare
d.Add "a", "Athens"   ' Add some keys and items.
d.Add "b", "Belgrade"
d.Add "c", "Cairo"
' An error occurs on the next line because the key already exists.
' The comparison mode is Text, so the keys are case-insensitive.
d.Add "B", "Baltimore" 

Applies To:

Date

History

Reason

April 2009

Modified examples.

Customer feedback.

Community Additions

Show:
© 2015 Microsoft