This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From14/07/1997 16:10:47
George Simmons #010180
Orbis Online
San Antonio, Texas, United States
To  
All


I have a form that contains 6 remote views in the data environment. Five of the views are set for optimistic table buffering with the other set for optimistic row buffering. I am using these views to query and make sure a value that is going to be entered is not a duplicate. If not a duplicate then I issue an INSERT followed by a =tableupdate()

The problem is that when one machine is running this application it seems as if no one else can access those tables until that form is released. Perhaps I am mistaken, but I thought that optimistic table buffering with views meant that copy of the data is pulled down to a temporary table, without locking the data. The only time I thought the records would be locked is when a =tableupdate() is issued.

This application will be rapidly moving toward multi-user usage and I am not sure what I am doing wrong here. Any help would be appreciated.

Environment:
OS: Win95
Back End: SQL Server 6.5
Front End: VFP 5.0

Thanks,
George
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe