Focal Point
[CASE-OPENED] FIELD NAME HIGHEST IS NOT RECOHNIZED

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

December 10, 2010, 11:41 AM
Prasad
[CASE-OPENED] FIELD NAME HIGHEST IS NOT RECOHNIZED
Below is a simple code replication of what exactly i need...


-SET &ECHO=ALL;

TABLE FILE CAR
LIST
CAR
COUNTRY
MODEL
LENGTH
ON TABLE HOLD AS CARD
END
-RUN

TABLE FILE CARD
PRINT
CAR
COUNTRY
MODEL
LENGTH
BY HIGHEST LIST
END
-EXIT


This was working fine in the version 7.6.10

But we upgraded to 7.7.02

and the same is not working instead it gives the error
the fieldname is not recognized: highest

Can anyone help me with this.

This message has been edited. Last edited by: Kerry,


7.7.02, sql server
Windows
all output (Excel, HTML, PDF)
December 10, 2010, 11:49 AM
Francis Mariani
BY HIGHEST LIST

What do you mean by that?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 10, 2010, 11:52 AM
Prasad
The above hold file card gives the report with the list from 1 to 18 ...and now in the second report i wanted to reverse the list...I mean the final output should print from 18 to 1 ..


7.7.02, sql server
Windows
all output (Excel, HTML, PDF)
December 10, 2010, 12:11 PM
GamP
The most probable reason for that is code tightening. In fact, the LIST word is a reserved keyword, and should therefor not be used. You can work around this by specifying BY HIGHEST E01 (which is the LIST field).


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
December 10, 2010, 12:32 PM
Dan Satchell
You could place a ? HOLD CARD after the first query to see the name given to the LIST column in the HOLD file.


WebFOCUS 7.7.05
December 10, 2010, 01:06 PM
GamP
LIST is always the first field after the BY's. So if you have no BY's it is E01, if you have 4 BY's then it is E05.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
December 10, 2010, 01:40 PM
Prasad
Thank you guys. Solution by Gamp worked..


7.7.02, sql server
Windows
all output (Excel, HTML, PDF)
December 12, 2010, 03:20 PM
j.gross
Assuming the generated field is still call "LIST" -- the parsing algorithm was apparently changed so that LIST is interpreted as a verb, despite its being the name of a field.

To force it to refer to the LIST column, just qualify it -- in this case,
BY HIGHEST CARD.CARD.LIST



- Jack Gross
WF through 8.1.05
December 13, 2010, 12:01 PM
Kerry
Hi Prasad,

Our internals viewed this topic and suggested that this looks like an issue to be fixed by programming, have you got a chance to open a case? If so, would you mind to send me the case number via a private message? If not, please contact Customer Support Services for a case. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.