Solved

Delphi vs. FoxPro

Posted on 1998-06-29
3
1,591 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
3 Comments
 

Expert Comment

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

Author Comment

by:bruck
Comment Utility
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 100 total points
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

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