Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record mysteriously getting locked
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Record mysteriously getting locked
Miscellaneous
Thread ID:
00270993
Message ID:
00270993
Views:
55
I have a form with a grid and have created a temporary cursor with buffering set to '5' and used this cursor in a few columns on the grid (the cursor is not the grid's RecordSource). My code fills the cursor with data (using INSERT INTO and GATHER), issues tableupdate and displays the grid. Then when the user presses next, I delete the records from the cursor, issue tableupdate, refill it with the new data, issue table update and refresh the grid -- At least that is what I am trying to do ...

What happens is that the DELETE command fails saying that the record is in use by another user -- But this is a temporary cursor that I created and am the only one using -- I don't understand how the record/file could be "locked" by another user.

Totally frustrated ...
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Next
Reply
Map
View

Click here to load this message in the networking platform