Accessing Foxpro2.6 or later in Delphi? How can I do such task?

        I have problem programming Foxpro database files. I  tried to access Foxpro (.dbf with its index .cdx). I didn't know how to access Foxpro with its index in order not to reindex Foxpro database again. Once I tried to program using ODBC Database , I found message "Could not find Installable ISAM". I didn't really know what's happened. I'm not sure  if I install any part of Delphi incompletely. Anyone can tell me what to do with this. Or if I have to install something else that provide access to  foxpro file?
Delphi_ExpertAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kretzschmarCommented:
hi delphi_expert,

as far as i know, you can use the dbase-native driver for accessing fox-pro. just set level entry in the driver to 25.

meikl
0
Delphi_ExpertAuthor Commented:
   Thankx for  kretzschmar, but if I access fox pro file with out using its index. I encountered searching problems. Whenever original program runs after changed be made to originaldata without using its proper index. I have to reindex database everytime to update it. How can I get out of such troubles... One more thing, if I have to, how can I reindex Foxpro database in code with delphi. Show me an example please...
0
NorthXCommented:
One option is to use a third-party tool called Apollo.  It correctly opens Foxpro files (version 2.6 and earlier, or free (i.e., not bound in the Foxpro database structure)).

You can read more about it here:
http://www.hallogram.com/apollo/index.html

It's got the advantage of mimicing foxpro access commands, so reindexing is as easy as saying tablename.reindex.

It's not cheap, but if you really need to hang onto those Fox tables (instead of a simple Fox export to dBaseIV routine which could get you around the whole issue), it could work for you.

Hope that helps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Delphi_ExpertAuthor Commented:
   Anyway, I found it didn't work with Delphi 5
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.