Subject Re[2]: [ib-support] select ... for update: bug or feature?
Author Daniel Rail
Hi,

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

Thanks Ann, for the proper info.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)