Hi there,

I've read a lot of discussions about VFP versus VS on this forum but here is something a bit different. Over the last 15 years I have developed two bigger program-suites (ERP/CRM/All kinds of internet stuff). The first one is written in VFP8/native VFP-Data and is maintained until today. The second one was written over the last 4 year and was built using VC.NET/VS2010 and SQLServer (Express) .It was planned as a replacement for the VFP-apps The customers using these programs are shops with a range from 1 to 25 users, maybe 30 - 40 in the future.

Now a lot of things have changed and I have to write a third one. This has to be done in quite a short time (approx. 6 months).
As the VFP-version is working very well , I think of writing something new by using VFP9 utilizing some fine enhancements from VFPX and using cursor adapters for data access. I would like to have the possibility to use VFP- or SQLServer-Data. My experience is that installing and maintaining SQLServer is more time-consuming and more complex, while VFP-Data is easier to maintain but not reliable für bigger customers. As I am in the beginning of the evaluation-process there are three questions which are some kind of starting Point for me:

1: What are the best books/papers/tutorials on cursor-adapters you can recommend?

2. As I understand it, it is necessary to have the same data-types in VFP and SQL-tables?

3. Have you done this and what are your experiences with usíng cursor-adapters usind VFP- and SQL-Data alternatively?

Best regards and many thanks in advance

Thomas