I am using Firebird with ADO.NET. In a distributed application, I need
to be able to "lock" a record for editing. Other, users should be able
to "read" the data, but should be informed that the record is in use
and the application will not allow the user to edit the data.
Table NOTES
NoteID
Note
User 1 starts a transaction to edit the NOTES table. User 1 is editing
NoteID = 100. User 2 attempts to edit NOteID=100.
How can my application notify User 2 that NoteID=100 is being edited
by User 1 but allow him to view a "read only" version? TIA