[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



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