Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
List Box forcing record locks
Message
 
 
À
11/07/1997 18:20:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00039610
Message ID:
00039716
Vues:
32
>I've been around the block about a dozen times or so on this one, so I thought I'd see if any of you have encountered similar situations, and if so, if you had any great ideas about it.
>Originally, I was using a grid control to add/edit/delete records in a table. Since user has a short-cut key for adding rows (which appends records), and the screen refresh is sometimes a little slow, I've run into a problem where I get "REcord locked by another user" messages when user is adding, editing records so quickly. I've decided on a cleaner looking, at least, approach of using a listbox with an appended record at the end, and text boxes above used to populate added records, edit, etc. However, I am still getting "Records locked by another user" messages.
>Any advice?
>
>Laura

Sounds like you are using Optimistic buffering. If so, try issuing an UnLock and a TableUpdate(.t.,.t.,"MyTable") after adding a new record. You may have to switch toe order of the Unlock and tableupdate. To see which works best. But I think the UnLock should be first.

HTH
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform