[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] (no subject)
- Subject: Re: [sqr-users] (no subject)
- From: bpelton@communitymedical.org
- Date: Tue, 12 Nov 2002 12:52:00 -0800
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
- Sensitivity:
Immediatly after openning the file, read one line into a dummy variables.
let $filename = '{FILEPREFIX}' || $filename
open $filename as 10 for-reading record=70
read 10 into $ignore_first_line:70
while #end-file = 0
do read-next-line
if #end-file = 0
let $valid = $yes
do validate-emplid
do validate-dedcd
if $valid = $yes
do check-existing-record
if $exists = $yes
do update-deduction-record
else
do write-deduction-record
end-if
else
do print-error
end-if
end-if
end-while
Brian Pelton
System Analyst
Community Medical Centers
Dan Lemos <dlemos@aeacu.com>@sqrug.org on 11/12/2002 12:44:10 PM
Please respond to sqr-users@sqrug.org
Sent by: sqr-users-admin@sqrug.org
To: "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
cc:
Subject: [sqr-users] (no subject)
Is it possible to open a file for reading but have it skip the first line
in
this file? The first line is a header and the data I need to pull from
this
file starts under this header.
Currently I am manually opening this file and deleting the first line but
would like to see if I can have this automated.
The file I am opening is a flat file with a fixed length layout.
Any help is appreciated.
Dan
_______________________________________________
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