1. François Van Lerberghe
  2. Valentina Database ADK
  3. Thursday, June 18 2015, 08:16 AM
  4.  Subscribe via email
Hello,

I realize I can update a record with an UPDATE sql command while another user has set a read and write lock on this record in a VCursor. Is it really the intended behavior ? Is the UPDATE sql command a "NoLock" command ?
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer
Currently, locks are working for cursors only. I mean, if you try to update/delete record using another cursor you will get an error since the record is locking by first one. UPDATE/DELETE sql statements ignore locks for now because we are going to implement "versioning" transactions (without any locks).
But, anyway, report it to the Mantis please.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Tested with local and remote db, within my application and ValentinaStudio, valentina 5.8.5 on Mac OS X
In ValentinaStudio,
1) make a SQL select command with RW lock, ServerSide
(SELECT myField1 FROM myDatabase WHERE RecID = 1)
2) open a new SQL tab and make a SQL update command on this locked record
(UPDATE myDatabase SET myField1 = 'SomeOtherValue' WHERE RecId = 1)
The update is done while the record is locked, without any error.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Ivan Smahin Accepted Answer
Are you sure that record is RW locked? Could you send me some example or at least select and update queries?
Is it local or remote db?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.