I'm using Firebird/Delphi 5/Interbase Express.

Thanks,
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: <ib-support@yahoogroups.com>
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.
To
> know that updates are safe you either have to use transactions or using
the
> 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
ahead
> > with their changes.
> >
> > How do I do this? Can this be controlled through transactions?
> >
> > Stephen