Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grids and 'Record In Use By Another User' Problem/Solution!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Grids and 'Record In Use By Another User' Problem/Solution!
Divers
Thread ID:
00313428
Message ID:
00313428
Vues:
66
GRID PROBLEM
I've been debugging an Error 109 in a form that has a Grid that has fields in it that are changed using a Replace command after a user changes a ComboBox value. On occassion I get a "Record In Use By Another User" and since I am using a Local View my computer is lying to me!

Well it seems to be a timing issue. I looked up some threads posted elsewhere. Bonnie was getting this error in a grid with a checkbox. That solution won't work because I am SCANning down all of the records in the local view and changing a value with REPLACE.

GRID SOLUTION :-)
I took and detached the ControlSource from the column that I was changing prior to doing the SCAN/REPLACE and then reconnect at the end of the SCAN loop and it seems to have permanantly gone away.

I have seen this same problem cropping up in some of my other apps but have never been able to pin it down. I know this happens sometimes in an APPEND BLANK or DELETE in a GRID as well.

Anyone have any comments or other hints. I think I have this one solved. I thought I would share my testing to help alleviate anyone else going through the same Frustation with hard to reproduce code.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform