DBase File I/O Rountines in FP

Christopher Yerry christopheryerry at yahoo.com
Thu Oct 20 13:32:17 PDT 2005


> >> Greetings,
> >>
> >> I'm on the road so checking for myself is not
really an option.
> >>
> >> Somewhere in the back of my mind, I was thinking
in either the 
v4.5 New
> >> Features Guide when File I/O functions were
introduced (or maybe 
4.8?)
> >> there was some sample code for natively reading
dbase files as I 
>recall.  Does anybody have that code typed-
>> in/available that they could email me
> >> a  copy?  I have to access a DBASE-III file, 
>> however it has to be updated
> >> and
> >> I cannot just convert to FP (using DBCopy) as I
>> will be stuck out on an
> >> island if Itry to do so.
> >>
> >> Regards,
> >> Keith


Kieth

DBase III uses a header that tells the structure (use
this for the map) the rest is flat file (aka non
filepro file)

Take notepad and remove the top to the beginning of
the data and save it (use save as) and map it using
filepro Non Filepro file it will work fine. 

Longer Version
Use the structure written in the first 100 or so bytes
it is written in text. Remove that part and save it as

/filepro/dBaseTable/table.txt
Create a non filepro file using the file structure of
the top part of the file (the part you did not use).
The rest is just a space delimited file just use it as
a non filepro file and you are done (add some indexes
etc)

Christopher Yerry
Pres CM Software
715 441 6175


		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com


More information about the Filepro-list mailing list