Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is in use by another user
Message
 
To
06/03/2001 08:43:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00482180
Message ID:
00485720
Views:
11
>Hello everybody. I know this is a topic already treated. But I do not know if it is resolved.
>It happens that when I workig with a Master-Detail Forms that contains a Grid Control for the detail and the buffer for the table of the grid is set to 5, sometimes I received the error message: "Record is in use by another user" and the table of the grid get locked and nobody that use this table in other process o forms can update any record.

I have the same problem but I'm leaning for this method to work.

REPLACE cDetail WITH "Tata" IN Detail

but not this:

SELECT Detail
LOCATE FOR parent=detail && position on the record
REPLACE cDetail WITH "Tata" && I think that it lock the child record

Hope it helps
Lead programmer of the free MIS Info Video(Frontend/player), Info 2 MIS or visit me at Steve's Tech Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform