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,

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.

Thanks
Mark

Richard,

Have you tried fully qualifying the field names in the Where clause ?

I opened a case about this problem. Developer's Studio works with the maintain but the server does not. Thanks for your help.