Focal Point
[SOLVED]LONG data type in oracle

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

August 30, 2016, 03:44 PM
susannah
[SOLVED]LONG data type in oracle
what a monster. this datatype seems to have characters embedded in it that make it split onto multiple lines (cells) when read.
Anybody have any idea how to work with these monsters?
Stripping out the 1013's work?

This message has been edited. Last edited by: <Emily McAllister>,




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 31, 2016, 03:41 AM
Tony A
That's worked for me in the past.

I guess that you are talking about the three main formats of HTML, PDF and XLSX?

Also, do not forget
   TYPE=REPORT,LINEBREAK='CRLF',$


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 
August 31, 2016, 10:57 AM
susannah
I figured out a w/a.
Leaving it as the oracle LONG format, I can read but can't hold b/c wf has no clue what that is.
so....
just faked a master for it and declared it to be /A4000V
then lo and behold I can read and hold it.
then process as normal.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID