Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 109 record lock?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Error 109 record lock?
Miscellaneous
Thread ID:
00357557
Message ID:
00357557
Views:
51
I discovered that when I am running my multi-user form in buffering mode 2 and press my Edit button I am allowed to edit my record at the end of the table, but when I press Prev and then edit to edit the previous record in the table, I get an error 109 which means the record is locked by another user. But I am running in standalone mode. So I hit Prev button again and hit Edit again and got the same error. I kept doing this for several times until I was about 10 records prior to where I started, then I was able to Edit the records without error 109.

I tried the command window and did UNLOCK ALL thinking that would unlock those locked records. How can some records be locked and some unlocked in single user form running mode. It almost seems as though VFP locked those records permanently the other day when I was testing with 2 users at the same time. And I can't unlock them. Any idea what's going on with this? If I can unlock those records or figure out how come they appear to be permanently locked, I will be home free.

Thanks again.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform