Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table remaining locked
Message
From
11/11/2000 06:21:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
08/11/2000 10:40:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00439251
Message ID:
00440686
Views:
12
>I have a form that uses several free tables and a dbc with local views.It
>is running on a Win95/98 workstation with the tables located on an NT 4.0 server. I have one table that is being locked somewhere in the processing and remains locked. The table remaining locked is a lookup table. It never has data written to it. Several views in the dbc are based on this table. It remains locked even after the user has saved and no add/edit processes are in progress. I do no explicit locks with code. I am using pessimistic buffering on my tables. This lock occurs only occasionally, not every time records are added to a table.What is causing the lock? Is it requerys on the views based on this table. What is causing the lock to persist?

Probably there are combo/listboxes using the tables as a rowsource. If so instead you might set your rowsourcetype to SQL and rosource to a select from them.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform