So, most of what we use FPW2.x for round here is data conversion. We get .SDF, .XLS and .TXT files from various places, convert the data and send it on. Some of it is coming from our mainframe & going to customers, some is coming from customers heading for our mainframe.
In these circumstances my preference is to use the low level file functions to read each record (fixed length records) then validate, break it up and convert it and write it out in its final form (either .DBF, .TXT, or .XLS)
My predecessor has been importing to a temporary .DBF, then reading this back, doing the data conversion and writing out the final file.
Does anyone have any clue as to which is more efficient? No reason other than curiousity. I've done scads of data conversion in my career and almost always done it this way --even in dBASE, though at times I did have to resort to useing BASIC...
Jen
A bipolar theory does not neatly describe a continuum.
Before millenium: chop wood, draw water. After millenium: chop wood, draw water.