Hi,

I've developed a few apps using VFP and a Codebook based framwork. The framework allows me to switch between views of VFP tables and views of Oracle or SQL Server tables. I believe there are a number of frameworks that allow you to switch between local and remote views.

I had to adopt the framework's way of handling data and not try to use my old techniques. The framework is built around business objects. The business object handles all the issues you need to when you want to edit data. You add properties and methods to add the business rules that are specific to the table you want to edit. I was able to salvage some of my old FPW code used to enforce the business rules.

It involved quite a bit of learning, but the results were worth the effort.

Good luck,

Paul


>We would like to develop a VFP application that will run with either a VFP database or a SQL Server database (depending on the size of the client). All applications that we have developed to date have used a VFP database. I am beginning to experiment with Remote Views and SQL Server. A couple of commands that we always used in the past do not see to work with Remote Views: RLOCK, CURVAL and OLDVAL.
>
>Why don't these commands work? How do we deal with multi user issues (limit access to records, detect changes by other users, etc...)?
>
>Thanks for the help,