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



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