Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Delphi vs. FoxPro

Posted on 1998-06-29
3
Medium Priority
?
1,752 Views
Last Modified: 2010-08-05
I have been developing with Delphi 1 (and a glance at version 2) at it's beginning and was very pleased with it's capabilities. Now, in a different environment, I work with Visual FoxPro 5. We are thinking of upgrading to VFP 6 as soon as it comes out, but voices tell us to not even think about it and migrate to Delphi 3 (and soon 4) as soon as possible before we pop out of VFP due to it's limited DB and Connectivity capabilities, and if we want to be approached seriously in the future.

How will Delphi (4!) handle my legacy Visual FoxPro databases (native?) and is it really worth wile to switch? Are there hard fact sheets with the differences between the two? Can you even compare them, as my experience with Delphi goes back to version 1?

Many thanks for any advise
0
Comment
Question by:bruck
[X]
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 Comments
 

Expert Comment

by:phet
ID: 1025827
Delphi will threat Visual FoxPro database as just another DBF file and you can use BDE to access it.
0
 

Author Comment

by:bruck
ID: 1025828
Sure? Because all my Visual ForPro tables are stored in a database, and are currently unacessible for Delphi in every way I try to open them. Does Delphi use an ODBC driver to connect, or does it have some native connection method? How does it handle the table relationships? Meanwhile I have bought Delphi 4 and I can still not get it to work? Does anybody have a working example. Regarding my other questions. Does anybody have any fact-sheets to compare the two?

Many thnaks
0
 
LVL 3

Accepted Solution

by:
d4jaj1 earned 300 total points
ID: 1025829
There aren't any fact sheets comparing Delphi to VFP, however, there are looks of technical info on the Inprise site.  a Foxpro driver is included with Delphi 4.  Here's a suggestion though.  Transfer your VFP files into native dBase file format.  Even if you get the Delphi FoxPro driver to work (not an easy task) it will be a bit slower than dBase format for use in Delphi.  Same holds true for linking to Access databases.  

As for table relationships, Delphi handles them quyite well - but you have to set the relationships in Delphi - not the table level.  For example, Delphi will allow you to delete a master record even if detail records exists (ignoring Ref. Integrety) if you don't make teh link in "Delphi".  It will basically ignore this, picture validation and secondary indexes if not set up at teh application level - though it will honor Primary keys.  By application level I mean -in a Delphi Form or Datamodule.  Setting these features in teh Database Desktop or client verion of VFP isn't enough.

Finally, is it worth while to switch.  Definiately - especially if your distributing apps.  The fact teh teh Delphi exe's are 10 times faster than interperted P code should be enough.   A little work in teh beginning to transfer your table to dBASE isn't too big of a problem (a couple of insert queries).

Good Luck.
Any questions , please add a comment.

Jay
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

636 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