Subject Re: [firebird-support] Re: Transaction Problem
Author Ann W. Harrison
sierraja2000 wrote:
> ok the invoice number is generate on table, but if user1 is
> view a invoice No. 1 and user2 need view then invoice No. 1
> some time. This generate a dead lock. I want that multi-user
> can view the some data. Sorry my english
>

There are no deadlocks on reading data, only on updates and
deletes. Ready the paper Carlos suggested. It will show you
how to create an auditable series of key values.

>> In the IBO site, there is a paper that comments some solutions to the
>> problem:
>>
>> http://www.ibobjects.com/docs/ti_AuditableSeries.ZIP
>>


Good luck,

Ann