Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Maintain for 7.7.01 Not Recognizing Compound Where in For All Next
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Maintain for 7.7.01 Not Recognizing Compound Where in For All Next
 Login/Join
 
Gold member
posted
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
 
Posts: 57 | Location: Philadelphia, PA | Registered: June 19, 2007Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 660 | Location: New York | Registered: May 08, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 57 | Location: Philadelphia, PA | Registered: June 19, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Maintain for 7.7.01 Not Recognizing Compound Where in For All Next

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.