Solved

foxpro emulator? / low-level SQL driver

Posted on 2006-06-11
6
399 Views
Last Modified: 2008-02-01
Hi,
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?
0
Comment
Question by:moruda
  • 3
  • 2
6 Comments
 
LVL 3

Accepted Solution

by:
pweegar earned 500 total points
Comment Utility
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.
0
 

Author Comment

by:moruda
Comment Utility
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.
0
 
LVL 32

Expert Comment

by:jhance
Comment Utility
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.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:moruda
Comment Utility
i guess we're going to need to dump the idea (and the program)
thanks
0
 
LVL 32

Expert Comment

by:jhance
Comment Utility
BTW, if there was such a product available, would you be willing to pay for it?  How much?
0
 

Author Comment

by:moruda
Comment Utility
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 program...it is a DOS based program after all
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Exchange and Third Party application. 8 59
Problem to setup 18 78
copyEvens challenge 6 63
Scripting vs. Programming languages 25 110
Purpose To explain how to place a textual stamp on a PDF document.  This is commonly referred to as an annotation, or possibly a watermark, but a watermark is generally different in that it is somewhat translucent.  Watermark’s may be text or graph…
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.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

772 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