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 (158823)



The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft Visual FoxPro for Windows 3.0b

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!
				

Modification Type:MajorLast Reviewed:3/17/2005
Keywords:kbbug kbfix KB158823