[Info-ingres] [openroad-users] formfeed is lost by report writer

[Bodo Bergmann]

The '\n' is a newline character (0x0A) rather than a formfeed (0x0c).

Bodo.

From: openroad-users at googlegroups.com [mailto:openroad-users at googlegroups.com] On Behalf Of Allan Biggs
Sent: Tuesday, April 4, 2017 4:43 PM
To: info-ingres at lists.planetingres.org
Cc: openroad-users at googlegroups.com
Subject: [openroad-users] formfeed is lost by report writer

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\nwidth/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
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-users+unsubscribe at googlegroups.com<mailto:openroad-users+unsubscribe at googlegroups.com>.
To post to this group, send email to openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com>.
Visit this group at https://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OFE457D510.8CE52C6C-ON802580F8.004E0E91-802580F8.0050D7C5%40CDCLN05.LVS.DUPONT.COM<https://groups.google.com/d/msgid/openroad-users/OFE457D510.8CE52C6C-ON802580F8.004E0E91-802580F8.0050D7C5%40CDCLN05.LVS.DUPONT.COM?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20170404/5371ca5d/attachment.html>