On Friday 05 January 2001 23:40, you wrote:

> At 10:12 AM 05-01-01 -0700, you wrote:
> >One thing I would like is a document explaining how Interbase does
> > locking.
>
> IB doesn't do user-applied locking at all. It has MGA (multi-generational
> architecture) and "locks" are managed internally according to isolation
> level, conflict resolution setting and a couple of other conditions that
> may apply.

No I don't expect to do user level locking but I do want to fully understand
the internal locking that Interbase does so I can think about errors like I'm
getting and understand why they are occuring. This is what Sybase has and
helped me understand how it worked.

> There's a description of the process in the LangRef notes for SET
> TRANSACTION. There is also quite a lot about it in the DevGuide under
> Working with Transactions.

I've read the DevGuide Working with Transactions many times and tried all the
options in there. The "SET TRANSACTION" will likely be talking about ODBC
isolation levels and locking but I'm a layer below that.

> For a link to a white paper about MGA, see
> www.interbase2000.org/ib_reallyuseful.htm.

This sounds good. I'll try it. Thanks again!

--
Brad Pepers
brad@...