Adam,

>> how do you place a lock on "a part" of a file? Can you define what "a
>> part" is?

A> I don't actually know the mechanisms that control it.

nobody appears to know. Yet I read about this phenomenon in this list
quite often. I gotta investigate more I guess.

>> A> This will cause the database engine to panic and shutdown,
>> A> disconnecting and rolling back all active connections (for SS)
>>
>> how can you succeed in locking a file or part of it that has been
>> open, and exclusively locked, by the Firebird server already?

A> SS doesn't open it exclusively, it must at least allow reading.

yes that's what I meant. But allowing reading doesn't mean allowing
other processes to *lock* the file. I might try several combinations
of flags to get a clearer picture.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================