foxpro emulator? / low-level SQL driver

Posted on 2006-06-11
Last Modified: 2008-02-01
does anyone know of any way that we can set up a SQL database for a FoxPro App, without re-writing the whole code--rather using some type of emulator or low-level driver that the app will believe it is using FoxPro but really be using SQL?
Question by:moruda
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Accepted Solution

pweegar earned 500 total points
ID: 16887258
It would be very difficult to do if your FoxPro app uses a lot of FoxPro specific commands to search/retrieve data (such as seek, scan, etc.).  Also you would have to redo your screens, reports, etc.

Might be better off just rewriting the app to begin with and have done with it.  You may also encounter problems with importing data from foxpro to SQL Server, esp. if you have multiline memo fields.  It's not a fun thing to do. There are however converts that work well that will convert your data.

Author Comment

ID: 16887590
We cannot rewrite the app. It's either junk it and get a new system or get something that tricks it to think its fox but really is SQL.
LVL 32

Expert Comment

ID: 16888442
It's an interesting idea, one that I've thought about in the past.  The problem is that the app <--> FoxPro interface is fairly complex and doesn't beaking down cleanly (as I understand it) into SQL that could be passed off to a SQL Server back-end.  So while I think it's possible to do this, in theory at least, the difficulty in doing so would make it a rather significant undertaking.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 16888553
i guess we're going to need to dump the idea (and the program)
LVL 32

Expert Comment

ID: 16890269
BTW, if there was such a product available, would you be willing to pay for it?  How much?

Author Comment

ID: 16890558
I could discuss this with my client, but I am not sure he wants it. This idea was a last ditch effort to save the is a DOS based program after all

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

739 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