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.
Back End: SQL Server 6.5
Front End: VFP 5.0
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe