>Hi all!!
>
>I am running to a problem, I need to develop an existing application in multi user environment that can be switch between different Database environments, I mean, SQL server or Native VFP.
>
>My First though was Remote View where I will change the connection pointing to different databases environment but the names of the tables and databases remain the same.
>
>But the problem is how I going to make record locking if Remote view look like does not perform that task.
>
>The application is not yet develops so I open to suggestion.
Back-ends like SQL Server typically do not support "file" or "record" locking as we're used to in Fox. If two or more users update a row (record), the last update is the one which persists.
Can you tell us more about why you might actually need locking in your application?
If, for example, you use pessimistic buffering, there are ways to simulate this on a SQL backend, such as including a flag column (field) that indicates that another user has "locked" a row and it can't be altered by anyone else until the flag is reset.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up