Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


foxpro emulator? / low-level SQL driver

Posted on 2006-06-11
Medium Priority
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 2000 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.
Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.


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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

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.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
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…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

721 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