Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Maximum Limit of Alphanumeric Define/Compute Fields
Go
New
Search
Notify
Tools
Reply
  
[CASE OPENED] Maximum Limit of Alphanumeric Define/Compute Fields
 Login/Join
 
Master
posted
As per documentation(WF8), maximum limit for alpha fields is 4095 characters.

But below sample code uses around 30,000 for field XYZ_1 and it still works fine in 8009.

Any one foresee any issues with beyond 4K characters?

-* File test_max_alpha_define.fex
 
-SET &XYZ='123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212112121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121211212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121211212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121221212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312122121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312122121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212112312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121211212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312122121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212112121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212122121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212ABC';
-TYPE &XYZ.LENGTH
-SET &XYZ=&XYZ || 'ABC';
-TYPE XYZ=&XYZ
-TYPE &XYZ.LENGTH
 
 
SET WEBVIEWER 	= ON
SET WEBVIEWALLPG = OFF
SET WEBVIEWCLOSE = OFF
SET WEBVIEWTARG	= OFF
SET WEBVIEWHELP = OFF
APP PATH IBISAMP
DEFINE FILE CAR
XYZ/I11 = &XYZ.LENGTH;
XYZ_1/A30600 = '&XYZ.EVAL';
END 
TABLE FILE CAR
PRINT
CAR
COUNTRY
DEALER_COST
RETAIL_COST
XYZ
XYZ_1
ON TABLE HOLD FORMAT ALPHA
END
-RUN
TABLE FILE HOLD
PRINT
*
HEADING
"" 
END
-RUN



Thanks,
Ram

This message has been edited. Last edited by: Ram Prasad E,
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The 4095 limit is a storage limit for fixed format files, 3968 is for FOCUS file storage and 4096 for XFOCUS field storage.

There is a 32k (roughly) limit that is for SQL field actual/usage, so WF is built to handle this length of Alpha fields.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Reply With QuoteReport This Post
Master
posted Hide Post
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Master
posted Hide Post
I have opened a case with IBI for this.
-Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
quote:
low sample code uses around 30,



Hi Ram,

Just reopening this.. What can be the maximum length that Alphanumeric can hold. i.e. A&listbox6.LENGTH

-SET &Phone_no = STRREP(&listbox6.LENGTH,&listbox6,02,'OR',1,',',&listbox6.LENGTH,'A&listbox6.LENGTH');

Thanks,
Ramya


WebFocus 7702
HTML
 
Posts: 73 | Registered: January 02, 2012Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi Ram

The function is not happening if the value exceeds A4096

Thanks,
Ramya


WebFocus 7702
HTML
 
Posts: 73 | Registered: January 02, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Maximum Limit of Alphanumeric Define/Compute Fields

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.