Focal Point
[CLOSED] Maintain for 7.7.01 Not Recognizing Compound Where in For All Next

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/724106735

September 30, 2010, 12:01 PM
RichardA
[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
Maintain Wizard
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
October 01, 2010, 12:55 PM
Dave Ayers
Richard,

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


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
October 06, 2010, 12:30 PM
RichardA
I opened a case about this problem. Developer's Studio works with the maintain but the server does not. Thanks for your help.


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