>Can anyone give me any reason why I would switch to Delphi or VB to run from Microsoft SQL Server - large database, instead of VFP6?
>
>Thanks
>Kev
>
>PS When is VFP7 being release?
Kevin,
I would think that all three (VFP, VBV and Delphi) would be able to provide you with satisfactory UIs against SQL data. However, there are a couple of additional thoughts that I would want to consider before going in any one direction. They are:
1) Do I need to manipulate data on the local machine to any great extent?
2) Do I have the expertise, time and ability to create a Middle Tier Business Object Model?
3) What talent is available locally for each of these platforms?
4) Is there another platform better suited to my needs?
5) How do I propose to allow users to gain access to the SQL-based data?
If the answer to #1 is 'No' (I do NOT need a lot of local data manipulation abilities) then the next question I'd ask is whether or not I want a thin or thick client? Not that this matters much but it will impact you during periods of product updates.
If the answer to #1 is 'Yes' then I'd consider FoxPro, depending on what and how I need to manipulate that data. Simple reports, for example, wouldn't require FoxPro; nor would they preclude it either.
VB is a great product to use if you follow the 3 tier ('n tier) model. So would Delphi and FoxPro.
There are lots of VB programmers out there vis a vis FoxPro or Delphi developers.
Delphi is apparently going to be ported to Linux - which I applaud and which will certainly extend its life.
There are many more considerations here but in my mind all three products would be able to give you a solid front end for a SQL backend.
I don't know if this helps much or confuses you more <g> but the question you ask really doesn't lend itself to a specific answer.
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.