PRB: "Operator/Operand Type Mismatch" Error on BROWSE

ID: Q98361

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SYMPTOMS

Comparing a date type field with a literal character string in the FOR clause of a BROWSE command may result in the error message "Operator/Operand Type Mismatch."

RESOLUTION

To solve this problem, do one of the following:

Use the CTOD() function to convert the literal character string to a date type, as follows:
```
      USE invoices
      BROWSE FIELDS ino, cno, idate FOR idate > CTOD("05/22/90")
```

Place the date within braces ({}) as follows:

      USE invoices
      BROWSE FIELDS ino, cno, idate FOR idate > {"05/22/90"}

MORE INFORMATION

This error is returned because a literal character string is a character type field rather than a date type field.

For example, the following statement

   USE invoices
   BROWSE FIELDS ino, cno, idate FOR idate > "01/01/91"

where "idate" is a date type field in the database, returns the above error.

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a errmsg compare curly brackets err msg KBCategory: kbprg kberrmsg kbprb KBSubcategory: FxprgBrowse

Last Reviewed: June 27, 1995