Re: SQL*Reportwriter 1.X using File DFLT and

From: Morten Larsen <xenemla_at_psab.posten.se>
Date: Thu, 21 Apr 1994 07:49:02 GMT
Message-ID: <CoLn1r.An6_at_psab.posten.se>


> From: Hayward_at_pobox.pds.med.umich.edu (Jeff Hayward)
> Newsgroups: comp.databases.oracle
> Subject: SQL*Reportwriter 1.X using File DFLT and getting FormFeeds
> Date: Fri, 15 Apr 1994 18:29:51 GMT
> Organization: University of Michigan Department of Pathology
>
> We have some old complicated reports that noone wants to recode. The reports
> pick up flat files and are happy. So we just set up a SQL*Report to create
> the flat files by sending it to File using DFLT. This has worked great, but
> now, for some unknown reason to me, without the DFLT printer def changing
> the reports will occasionally throw in Form Feeds characters at the ends of
> what it thinks are pages, or the beginning of new record lines. This form
> feeds are, of course, crashing the report generators since formfeed should
> not be a part of the flat files. I could write a pre-processor to take out
> the offending form feeds but there has to be a way to have SQL*Reports stop
> putting them in isn't there? I checked and the def for DFLT does not have
> any codes in it.

SQL*ReportWriter assumes that pages are separated by Form Feeds unless you redefine it to something else. Putting :ff=: in your DFLT printer def will solve your problem. That will define Form Feed as an empty string.

--
Morten Larsen
Enea Data AB
Nytorpsvagen 5 B
S-18323 TABY, SWEDEN
+46-8-6385016
morten_at_enea.se
Received on Thu Apr 21 1994 - 09:49:02 CEST

Original text of this message