Microsoft KB Archive/158823

= 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

-

APPLIES TO


 * 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.



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.