1. François Van Lerberghe
  2. Valentina Database ADK
  3. Donnerstag, Juni 18 2015, 08:16 AM
  4.  Abonnieren via E-Mail
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 ?
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories