|Subject||Re: [firebird-support] Re: How to implement SQLServer's WITH(NOLOCK) statment?|
>Not that nasty if you keep the result set small, as WITH LOCK operates
>>>>> No SELECT IS ever locked in Firebird, you've been told that
>>>>> a few times now.
>>>> How about SELECT...FOR UPDATE WITH LOCK
>>> Right, I'll rephrase, "no plain select is ..." ;-)
>>> Either way, I don't think such a select would lock out other
>>> readers, but would only lock for other updaters?
>> It will lock other readers as well. ;-)
> Hm, nasty.
on record level. ;-)
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and