Solved

Delphi vs. FoxPro

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
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…

763 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