[Info-ingres] formfeed is lost by report writer

[Allan Biggs]

For this work I am working on a windows 7 laptop with the community 
edition of ingres installed on it. though the database is on a 10.2 Linux 
server. 

I have a multiline field in OpenROAD which maintains a table with 
attributes which are varchar (250) not null with default
looking at the table via isql - you can see \n where the form feeds are.

I am running a report writer (.rw) which gives a text file (actually a 
python script) the"\n"s are somehow truncating the field everything after 
\n is lost for that field. 

Prior to introducing the form feeds  the other parts of the attribute were 
displayed in the output file 

Does anyone have any idea what is going on here?

Note - I have removed the 200+ spaces to make this readable 

Thanks
Allan 


this is the result for row in an
sql query just prior to running report writer 
|    prop_desc2           [lots of spaces removed] |    test_gp_desc2     
[lots of spaces removed]                             |
|Mean thickness\nper reel [lots of spaces removed] | Calculated from\n
width/length/  \nweight/density [lots of spaces removed] |

Here are fragments of 
report writer script for the same row 
.QUERY 
select   distinct 
 disp_kind,
 prop_desc2 ,
 test_gp_seq, 
 n_tests ,
 min_values_for_std ,
 test_gp_id ,
 av         , 
 sds        , 
 test_gp_desc2,
 srt_order,
 etc .......

.FORMAT prop_desc2    (c250)
.FORMAT test_gp_desc2 (c250)


.PRINTLN "worksheet1.write(",  $actual_row_number,  "," , 0  (f4),  "," , 
"'" prop_desc2             , "'", "   ,fmtwrap)"
.PRINTLN "worksheet1.write(",  $actual_row_number,  "," , 1  (f4),  "," , 
"'" test_gp_desc2      , "'", "       ,fmtwrap)"



the text file produced 
worksheet1.write(           25,   0,'Mean thickness  [lots of spaces 
removed]   '       ,fmtwrap)
worksheet1.write(           25,   1,'Calculated from [lots of spaces 
removed]   '       ,fmtwrap)






This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

          http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20170404/76b315f3/attachment.html>