row locking
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Does Sybase SQL Anywhere 8 support row lock? I'm writing a MFC application that already implemet row lock with Oracle via ODBC. In Oracle I use: 1. Start a transaction 2. Lock a record (SELECT * FROM Table WHERE ID = 1 FOR UPDATE NOWAIT) 3. Wait for a user record's modify 4. Commit If another user tries to modify the record, Oracle returns an error message. Is it possible to implement this with Sybase' server ? Thank you Vin. vin