[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Flat File
- Subject: Re: [sqr-users] Flat File
- From: "Larry Roux" <lroux@syr.edu>
- Date: Sun, 10 Apr 2005 13:46:31 -0400
- Delivery-date: Sun, 10 Apr 2005 12:47:38 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Can't you just check for the existence of data?
ie
if (RTRIM($inputline,' ') <> ''
add 1 to #count
do insert-line
end-if
Larry Roux
Syracuse University
lroux@syr.edu
>>> radhika_05@hotmail.com 04/10/05 12:39 PM >>>
Hi,
I am reading a flat file and inserting into tables(Inbound
interface). I
am having a problem reading it,
when i reach end of file it is still looking for data and taking it as
empty
record. The program is working good except that the number of errors is
added by 1 though it's not.
I use While loop for looping through the flat file and also i am
checking
end of file condition too. Is this the bad flat file or am I missing
something?
Thanks. Any input would be appreciated.
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
_______________________________________________
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