Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FGETS() vs. IMPORT/APPEND FROM
Message
From
18/11/1998 09:52:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
FGETS() vs. IMPORT/APPEND FROM
Miscellaneous
Thread ID:
00158744
Message ID:
00158744
Views:
46
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.
Next
Reply
Map
View

Click here to load this message in the networking platform