Yes. Not the best user experience imo. I first test the record to see if I
can update it. If I can I proceed with the lock. If I can't I tell the user
that someone else is editing the record. They have to try againlater.
Alan

On 07/01/2013 12:07 PM, "W O" <sistemas2000profesional@...> wrote:

> So, 535 should read again the row, getting now the updated version from
> 526?
>
> Greetings.
>
> Walter.
>
>
>
> On Sun, Jan 6, 2013 at 8:44 PM, Alan McDonald <alan@...> wrote:
>
> > **
> >
> >
> > But 535 will need to re acquire the row before it can update.
> >
> > Alan
> > On 07/01/2013 11:34 AM, "W O" sistemas2000profesional@...> wrote:
> >
> > > Hello everybody
> > >
> > > - Transaction 510 inserts a new row
> > > - Transaction 510 commit
> > > - Transaction 526 start
> > > - Transaction 526 updates the row inserted by transaction 510
> > > - Transaction 535 start
> > > - Transaction 535 wants to update the row inserted by transaction 510
> but
> > > unsuccesfully because transaction 526 has locked it
> > > - Transaction 526 commit
> > >
> > > Can now transaction 535 update the row inserted by transaction 510? In
> > this
> > > case, updates makes for transaction 526 will be lost, right?
> > >
> > > Or transaction 535 should first to read the new row commited (the 526)
> > > before making the update?
> > >
> > > Greetings.
> > >
> > > Walter.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Visit http://www.firebirdsql.org and click the Resources item
> > > on the main (top) menu. Try Knowledgebase and FAQ links !
> > >
> > > Also search the knowledgebases at http://www.ibphoenix.com
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]