Focal Point
Focus Field limitation

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

November 06, 2006, 08:02 PM
Viral
Focus Field limitation
Hi,

I am facing problem when I trying to save the data into focus file. It allows me upto 550 characters to store for the particular field. But real field is 4000V. As soon as I modify to 4000V it error out while saving to focus file.
Shows Error "(FOC397) Length of Fields on Focus File Segment Exceeds 4000 bytes."
If I run the report without saving to focus file it works for me only booms out when try to save in the focus file.
Pls. let me know if any kind of limitation to focus storage. Thanks in advance for all your suggestions.


WF 7.6.2/ OS WIN2003.
DM 7.6.2
November 07, 2006, 04:26 AM
hammo1j
I would suggest you try using XFOCUS format. It uses a larger page size than 4096 and should be able to fit your variable.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
November 07, 2006, 07:31 AM
Jim_at_LM
Viral:

Be sure to put the V field on its own unque segment (with no other fields). And, use XFOCUS to store the file in 8K blocks.

Jim


WebFOCUS 7.6.11, WINDOWS, HTML, PDF, EXCEL
November 07, 2006, 07:05 PM
Viral
Thanks all for your inputs !

It works after I change to the XFOCUS format.

Once again thanks for quick response.


WF 7.6.2/ OS WIN2003.
DM 7.6.2