[CLOSED] Maintain for 7.7.01 Not Recognizing Compound Where in For All Next
I have a maintain program which works in my 7.6.8 environment, but when I deploy it to 7.7.01 it has a problem. It has the following code:
For All Next mhmes.ROOT_SEG.CLIENT_ID mhmes.ID_SEG.BSU_ID mhmes.FAC_SEG.FACILITY_NO mhmes.MON_SEG.YEAR mhmes.PAC_SEG.PAC mhmes.TYPE_SEG.SERV_TYPE Into stkMHMESList Where FACILITY_NO EQ entryFacilCode AND MONTH EQ searchMonth AND YEAR EQ searchYear AND PAC EQ entryPAC AND SERV_TYPE EQ displayServiceType AND THER_TYPE EQ displayTherapyType AND FUNDING EQ displayFundingSource AND RECORD_TYPE IN ('2','6') AND GROUP EQ groupCode;
It does not work. It won't pull any values unless I remove all but one of the comparisons. They work individually but don't work together.
Is this a known issue or am I doing something wrong?This message has been edited. Last edited by: RichardA,
Sandbox Version: 8.1.04 Sandbox Platform: Windows 2008 R2 Testing Version: 7.7.02M Testing Platform: Windows Server 2008 R2 WF Production Version: 7.7.02M Production Platform: Windows Server 2008
September 30, 2010, 01:59 PM
Richard There is no known issue with compound where clauses. I will set up a test here, but it would be great if you could send me your Master file. Zip it and send it to Mark_Derwin@ibi.com. You have to zip it otherwise outlook will strip it.
October 01, 2010, 12:55 PM
Have you tried fully qualifying the field names in the Where clause ?