I have masterfile with several joins and I get an error when I execute the fex against it. I have researched and checked several possible causes, but still get the error. The field in question is the same format as the join field in the parent. What's causing this error?
(FOC1131) INVALID FIELDNAME CO_NBR FOR IXFLD. EMP-VIEW LN 93
WF 5.3.3This message has been edited. Last edited by: Kerry,
November 05, 2010, 11:33 AM
dbeagan
You will probably need to provide the master and fex. Even better if you could reproduce the error on an IBI sample file such as CAR.
Remember, a particular error message can have many different causes and situations where it might occur. Someone here might be able to get a lucky guess to solve your issue, but better would be for you to start by providing the master and fex.
WebFOCUS 8.2.06
November 05, 2010, 02:45 PM
db
Error message: (FOC1131) INVALID FIELDNAME PRISM_CO_NBR FOR IXFLD. EMP-VIEW LN 93 1 0 NUMBER OF RECORDS IN TABLE= 124459 LINES= 124459 0
And what is the Master and Field on the othere side of the join ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
November 07, 2010, 11:00 PM
Dan Satchell
The error message refers to your foreign key, but your host key field, PRISM_CO_NBR, occurs twice in the EMP-VIEW master - once in the EMPLOYEE segment and again in the COMPANY segment. Maybe that is the problem.
WebFOCUS 7.7.05
November 08, 2010, 09:54 AM
db
Changed the alias to COMPANY_NBR in the COMPANY segment and didn't get the error. However, I had tried that before and still got an error. It's working now. Thanks, I appreciate all reponses.