Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids and 'Record In Use By Another User' Problem/Solution!
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Grids and 'Record In Use By Another User' Problem/Solution!
Miscellaneous
Thread ID:
00313428
Message ID:
00313428
Views:
69
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.
Next
Reply
Map
View

Click here to load this message in the networking platform