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
  • 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.
Gigs: Get Your Project Delivered by an Expert

Select from 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.


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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mapAB Challlenge 35 142
wordcount challenge 11 121
python sqlite question 11 46
Installed softare without GUID 6 73
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
This is about my first experience with programming Arduino.
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 …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

813 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now