Subject Re: [ib-support] select ... for update: bug or feature?
Author Ann W. Harrison
At 08:04 AM 2/18/2003 -0400, Daniel Rail wrote:

>Firebird is a multi-generational architecture(MGA) database server. What
>that means, is that a record contains multiple versions of itself when
>being edited,

Right.

> so this means(I think I got it right) that more than one
>person can work on the same record and the last one to commit makes
>the changes.

No. Other transactions can read the record - reading an old
version - but attempts to update a record that has uncommitted
updates - or actually any updates you can't see - will cause
an error.


Regards,

Ann
www.ibphoenix.com
We have answers.