This error is pointing to the .acx file (see below). I don't understand why there are so many lines in the DCSHOUSG04 segment that look the same to me. Thank you in advance. I suspect the error is due to the syntax for referencing the DCSHOUSG03 keys './' specifically, but I am not certain. Any help will be appreciated.
WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively; excel, html, pdf
There is no reason for all those lines. I would take them all out except for the first occurrence. As for the error, I would write:
KEYFLD=POD/LOCATION, IXFLD=POD/LOCATION
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
June 07, 2012, 12:02 PM
Deana
Daniel, Thank you for your help.
Using the synonym refresh option, which I found this morning, I was able to tweak your suggestion and get this error fixed.
The synonym refresh created different syntax FOREIGN_KEY_COLUMN=LOCATION/POD and PRIMARY_KEY_COLUMN=LOCATION/POD. When I tried using the refreshed synonym, I received an error indicating the KEYFLD and IXFLD were missing. I the original code from KEYFLD=./POD/LOCATION, IXFLD=CELL/POD/LOCATION to KEYFLD=LOCATION/POD, IXFLD=LOCATION/POD.
The only difference from your post was the order of the fields.
WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively; excel, html, pdf