>
>>>>> 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.

Not that nasty if you keep the result set small, as WITH LOCK operates
on record level. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com