Hi Bill,

I am in the same boat (or soon to be) - I just posted a thread regarding VFP problems with tables having a "data lag". I have a feeling that I am going to have to rewrite this app into at least something that is CS backend as this should get around the local (caching I suppose) of VFP data using older style free tables. In my case, I will have to get an okay from the client to begin the process of rewriting to a SQL backend - will probably leave that discussion until after Christmas when they are hopefully feeling happier :-)

I poked around the cursor adaptor class a while back (when not really "serious" about making any changes) and did not get far so will probably have to delve into that again. I know Tamar wrote an article on CA's (if I recall) but I still did not get anything going.

Albert


>Hi,
>
>I have an app with 45+ users on a File Server network. It has been working well for several years and I have a lot of functionality built into it. The problem is it was conceived many years ago and is table based with no views. The client is considering using MS SQL Server due to the need for security. I realize that my DB design is antiquated so I am considering a re-write of the app. I have no experience with C/S and little with SQL Server so I am trying to learn both. My question is what would be the best course for re-writing the app; (using a Promatrix Framework)
>
>1- Build local views then remote views?
>2- Views or CursorAdapters?
>3- What major issues must I consider in my code?
>4- Which version of SQL Server 2012 can I download for development/testing that is free?
>
>Any help suggesting the best path for me to conquer this task would be appreciated. I know it will take time but some guidance will help.
>
>Thanks in advance,
>
>Bill