What is the syntax in Firebird to have a lock on select (not on update, delete).
For example :
user 1 : select.. for update nowait
user 2 : select .. for update nowait -> exception on lock select.
I am this comportment in Oracle and I'd like to have the same in Firebird.