KB158823 - FIX: You receive an "Operator/Operand type mismatch" error message when you execute a SQL-SELECT command with the IIF function in Visual FoxPro 3.0 and 3.0b

Article ID: 158823

Article Last Modified on 3/17/2005

Microsoft Visual FoxPro 3.0 Standard Edition
Microsoft Visual FoxPro 3.0b Standard Edition

This article was previously published under Q158823

SYMPTOMS

In Microsoft Visual FoxPro 3.0 and 3.0b, an Operator/operand type mismatch error occurs when executing a SQL-SELECT statement that includes the IIF() function.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro 5.0.

MORE INFORMATION

Steps to Reproduce Behavior

Create and run a program that contains the following code:

  DIMENSION la[ 2]
  la[ 1] = .F.
  la[ 2] = "???"

  PRIVATE ln
  ln = 1

  SELECT type FROM foxuser ;
     WHERE IIF( ln= 1, .T., la[ ln] = "AAA")   && ln is always 1!

Additional query words: VFoxWin Public kbdse

Keywords: kbbug kbfix KB158823