Sample C code using CODEBASE for reading .DBF file requested please
I have an inherited MS C development environment which I usually use for reading Btrieve files and writing out to dBase (.dbf) files; this is done by a prewritten function extractToDbase which uses Codebase.
I now have a need to read in one of these DBF files, update a field, then write out a new dbf file.
Unfortunately there is no prewritten function supplied for reading dBase files, my "skills" are no where near good enough for me to write one, and I can't find any Codebase manuals anywhere (locally or on the net).
Ideally I'd like to read in the dbf file using Codebase, but an alternative would be to unload the file to text first; either needs to be coded in C.
I would be very grateful if someone could post some sample code. Once I've got the gist of it, I should have no problem amending it to what I need.
Many thanks,
Rob
I now have a need to read in one of these DBF files, update a field, then write out a new dbf file.
Unfortunately there is no prewritten function supplied for reading dBase files, my "skills" are no where near good enough for me to write one, and I can't find any Codebase manuals anywhere (locally or on the net).
Ideally I'd like to read in the dbf file using Codebase, but an alternative would be to unload the file to text first; either needs to be coded in C.
I would be very grateful if someone could post some sample code. Once I've got the gist of it, I should have no problem amending it to what I need.
Many thanks,
Rob
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Kent,
The file is sent to users and probably viewed in Excel.
To give more indication on the format of the files, whenever I need to manually update these files I either use the dbu utility or I amend in Excel and then Save As DBF 3 (dBase III).
If I can get started with the syntax then I'm hoping everything else will fall into place.
Rob
PS "Ideally I'd like to read in the dbf file using Codebase, but an alternative would be to unload the file to text first; either needs to be coded in C." Yes, I've just realised how silly that sounds as obviously I need to read the file in either situation!
The file is sent to users and probably viewed in Excel.
To give more indication on the format of the files, whenever I need to manually update these files I either use the dbu utility or I amend in Excel and then Save As DBF 3 (dBase III).
If I can get started with the syntax then I'm hoping everything else will fall into place.
Rob
PS "Ideally I'd like to read in the dbf file using Codebase, but an alternative would be to unload the file to text first; either needs to be coded in C." Yes, I've just realised how silly that sounds as obviously I need to read the file in either situation!
ASKER
I've read elsewhere that I could read it byte by byte as the dBase structure is published and relatively straight forward, so I guess that's another angle I can explore....
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The file is sent to users and probably viewed in Excel.
To give more indication on the format of the files, whenever I need to manually update these files I either use the dbu utility or I amend in Excel and then Save As DBF 3 (dBase III).
ROb