>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?

The most critical point is that VFP has no decimal type.
VFP's Numeric is misleading,
and can give you some nasty surprises.

>
>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