RE: [sqr-users] Processing each record

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

That's a good restatement.  The begin-select ... end-select paragraph
contains a list of fields and any number of SQR commands.  All the fields
for each record "appear" at the same time.  After that, the SQR commands are
executed from top to bottom, even if some of them are between fields.  To
print something after reading each record, you could put the print command
in the begin-select ... end-select paragraph.  Usually, putting print
commands (or any SQR commands) in the header or footer means you want the
commands to be executed right before the page is sent to the printer.

I remember, from this morning, that you had a test of #page-count in the
begin-heading ... end-heading paragraph.  I think that would work, but only
for the first page that your SQR program prints, not the first page of each
work order.  You might try setting #page-count to 1 (or maybe to 0) each
time you read a new record (I don't know whether SQR allows it).  You might
try printing into the heading area from outside the begin-heading ...
end-heading paragraph.  Or, if you know exactly what goes on what page,
don't use the heading feature at all; control all the printing yourself.

-----Original Message-----
From: Ottaway, Eric (PS, GNF, Contractor) [mailto:Eric.Ottaway@gnf.com]
Sent: Friday, September 19, 2003 11:33 AM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] Processing each record


I sent a question earlier, but perhaps I can get better feedback if I pose a
more simplier question.
Again, I'm new at SQR, so where in a SELECT statement is each record
processed. I'm trying to flag when a new record is found so that before each
record the program looks in the header section to print a logo and footer on
the first page.

Thanks a bunch,


Eric B. Ottaway

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

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