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

Posted on 1999-12-04
Medium Priority
Last Modified: 2010-04-06
        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?
Question by:Delphi_Expert
  • 2
LVL 27

Expert Comment

ID: 2255984
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.


Author Comment

ID: 2258481
   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...

Accepted Solution

NorthX earned 150 total points
ID: 2308544
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:

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.

Author Comment

ID: 2322665
   Anyway, I found it didn't work with Delphi 5

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

592 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question