RE: [sqr-users] blank line being inserted unexpectedly while issuing

[edwin.hommes@bluewin.ch]

Hi Marc,

As suggested you could try something like
"print $var (+1,1) | 'X' " 
to see if your select parses a blank value

Some thing else might be your pagesize if the break appears at regular intevals
(every 42 lines or so). If so, you should increase your page-size to 32000.
Alternatively you could change your print command to a writeline command.

Hope this helps,
Edwin



Beginn der beigefügten Nachricht

From: marc pechaitis <fromthehills@gmail.com>
Subject: [sqr-users] blank line being inserted unexpectedly while issuing
  print commands
Date: Mon, 11 Apr 2005 19:27:17 -0600
To: sqr-users@sqrug.org

Hello All -
You've been super helpful to me in the past, and I've got another
problem that has me stumped.

I am writing a report that selects a row of data from a table and
based on the data in that row, it may decide to omit the line from the
report.

So let's say I have table:
row 1 - a1
row 2 - a2
row 3 - a3
row 4 - b1
row 5 - b2
row 6 - b3
row 7 - c1
row 8 - c2
row 9 - c3

And I know that, based on the content of row 5 (b2) that I want to
omit rows 4-6 (the b's). I've got the logic working so that all three
rows are omiitted, but for some reason the output is:

a1
a2
a3

c1
c2
c3

and not:
a1
a2
a3
c1
c2
c3

I'm just using a basic "print $var (+1,1)" command and have been
through the code about a million times to see if I might have an extra
"print" statement in my exclusion processing, but I can't find
anything.

Has anyone encountered anything like this? Any suggestions of things
to check that could cause this?

Thanks!
Marc



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users