Subject Re: [ib-support] Controlling updates to the same record by 2 users
Author Stevio
I'm using Firebird/Delphi 5/Interbase Express.

Stephen (also, please no more look at the docs replies - I have been looking
at various things :-)

----- Original Message -----
From: "Jason Chapman (JAC2)" <jason@...>
Newsgroups: egroups.ib-support
To: <>
Sent: Friday, August 02, 2002 12:34 PM
Subject: Re: [ib-support] Controlling updates to the same record by 2 users

> Stevio,
> What are you coding in and what components / data access are you using.
> know that updates are safe you either have to use transactions or using
> BDE updateWhereAll option.
> More info, better answer ;-)
> Jason Chapman
> JAC2 Consultancy
> <redeagle@...> wrote in message
> > I have a problem which I'm sure many of you must have dealt with.
> >
> > I have the problem where two users can open the same record at about the
> > same time, one user could then update the record and then the other user
> > could also update the record. The first user's changes will be lost or
> > overwritten by the second user.
> >
> > What I would like to happen is that the changes by the second user are
> > rejected, or at the very least they are given a warning to say that this
> > record has been updated since they opened it and do they want to go
> > with their changes.
> >
> > How do I do this? Can this be controlled through transactions?
> >
> > Stephen