Focal Point
Trouble in READ - 716 version

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

December 04, 2006, 09:47 AM
Kamesh
Trouble in READ - 716 version
Hi,
Saving a hold file and read it later to get the values. In 716 version, it reads the value prefixed with the length of value. It works fine in 533 version.

Ex:
TABLE FILE CAR
PRINT COUNTRY
ON TABLE SAVE AS TEST
END
-RUN

-READ TEST &COUNTRY.A25.
-RUN

OUTPUT:
SUPPOSED TO BE USA, FRANCE,...

But it is printing as 000003USA, 000006FRANCE.

Can somebody let me know is there any setting I have to do or is this the way 716 will work?


WFConsultant

WF 8105M on Win7/Tomcat
December 04, 2006, 10:05 AM
Tony A
Kamesh,

What is your data source?

This has been covered multiple times and is due to the default change in VARCHAR behaviour with most SQL data sources.

I'm sure that the above comment will trigger the memory ......

SQL SQLMSS SET VARCHAR OFF

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
December 04, 2006, 10:27 AM
Kamesh
Thanks Tony. SET VARCHAR OFF did the trick.


WFConsultant

WF 8105M on Win7/Tomcat