i know this is about MySQL, but there is no 4GL forum, so i'm hoping one of you experts might know:
we have an application that uses Progress (on a unix system) that imports data from .csv files and writes the various fields to the database.
one particular type of .csv file does not have a newline (CR) at the end of its last line, and this last line is therefore being ignored by the importer application.
the consultant who programs the this application (via a script, i do not know which), has told us that every line *must* have a carriage return in order to be read, that if it doesnt have a carriage return it cant be read.
I find this hard to believe. I have fairly strong knowledge of C and variant languages, and can't imagine such a imposed restriction. the problem is that to change the application which writes the .csv file prior to database import will be painful due to manufacturing and regulatory reasons.
can you give me some insight on this?