Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table remaining locked
Message
De
11/11/2000 06:21:13
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
08/11/2000 10:40:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00439251
Message ID:
00440686
Vues:
10
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform