Share via


Available Data Types and Operators

Applies To: Windows 7, Windows Vista

The Compatibility Administrator tool uses a form of SQL to query your custom-compatibility databases.

Available Data Types

You can use any of the following data types when querying your customized-compatibility databases in the Compatibility Administrator.

  • Integer. A numerical value with no fractional part.

Note

All integers are unsigned because none of the attributes can have a negative value.

  • String. A series of alphanumeric characters manipulated as a group.

  • Boolean. A value of True or False.

Available Attributes

The following table shows all of the available attributes you can use while querying your customized-compatibility databases in the Compatibility Administrator.

Attribute name Description Data type

APP_NAME

Specifies the name of the application.

String

DATABASE_GUID

Specifies the unique ID for your compatibility database.

String

DATABASE_INSTALLED

Specifies if you have installed the database.

Boolean

DATABASE_NAME

Specifies the descriptive name of your database.

String

DATABASE_PATH

Specifies the location of the database on your computer.

String

FIX_COUNT

Specifies the number of compatibility fixes applied to a specific application.

Integer

FIX_NAME

Specifies the name of your compatibility fix.

String

MATCH_COUNT

Specifies the number of matching files for a specific, fixed application.

Integer

MATCHFILE_NAME

Specifies the name of a matching file used to identify a specific, fixed application.

String

MODE_COUNT

Specifies the number of compatibility modes applied to a specific, fixed application.

Integer

MODE_NAME

Specifies the name of your compatibility mode.

String

PROGRAM_APPHELPTYPE

Specifies the type of AppHelp message applied to an entry. The value can be 1 or 2, where 1 enables the program to run and 2 blocks the program.

Integer

PROGRAM_DISABLED

Specifies if you disabled the compatibility fix for an application. If this is True, the Compatibility Administrator does not apply the fixes to the application.

Boolean

PROGRAM_GUID

Specifies the unique ID number for an application.

String

PROGRAM_NAME

Specifies the name of the program that you are fixing.

String

Available Operators

The following table shows all of the available operators that you can use while querying your customized-compatibility databases in the Compatibility Administrator.

Symbol Description Data Type Precedence

>

Greater than

Integer or String

1

>=

Greater than or equal to

Integer or String

1

<

Less than

Integer or String

1

<=

Less than or equal to

Integer or String

1

<>

Not equal to

Integer or String

1

=

Equal to

Integer, String, or Boolean

1

HAS

A special SQL operator used to check if the left-hand operand contains a substring specified by the right-hand operand.

Left-hand operand. MATCHFILE_NAME, MODE_NAME, FIX_NAME

Note
Only the HAS operator can be applied to the MATCHFILE_NAME, MODE_NAME, and FIX_NAME attributes.

Right-hand operand. String

1

OR

Logical OR operator

Boolean

2

AND

Logical AND operator

Boolean

2

See Also

Concepts

Using the Compatibility Administrator
Known Compatibility Fixes, Compatibility Modes, and AppHelp Messages

Other Resources

Testing and Mitigating Issues by Using the Development Tools