Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sticky Record Lock
Message
From
13/06/2002 14:32:47
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00665074
Message ID:
00668146
Views:
19
Just to be sure of the question, are you saying that (regardless of whether transaction is happening) when you issue the UNLOCK, the record does not actually get unlocked. ie.

Table Buffering is on
Editing takes place
In code you issue

SELECT (recordsource)

llSuccess = TABLEUPDATE(.T.)

UNLOCK IN (recordsource)

* and when you test from another machine, it is still locked?

Albert

>Using automatic record locking with table buffering, updating 1 record in 1 table, record stays locked until issuing an UNLOCK.
>
>I've tried running the same update inside and outside of a transaction, and always the same results--record is updated, but stays locked.
>
>This is only happening in one table.
>
>Comments?
>
>TIA,
>
>Thomas
Previous
Reply
Map
View

Click here to load this message in the networking platform