Yes, I do the dummy update to lock other users to update/delete the
record. (So they are allowed to read the record).

--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> not sure what you are getting at here
> if you also SET MARKERFIELD=1, then you can find these records by
SELECT *
> FROM TABLE WHERE MARKER RECORD=1 then set them to 0 after you do
what you
> want.
>
> Are you trying to lock other users out?
>
> Alan
> -----Original Message-----
> From: supertokkie [mailto:martinstuij@c...]
> Sent: Sunday, 8 September 2002 19:20
> To: ib-support@y...
> Subject: [ib-support] Re: Savepoints
>
>
> When the user wants to edit a record, I start with a transaction.
> Then I do a dummy update:
>
> UPDATE PRODUCTS
> SET PRODUCTID = 1
> WHERE PRODUCTID = 1;
>
> Now the record is not writable for other users. After this
update, I
> want to set a savepoint. So that I can always go back to this
point
> (after the dummy update).
>
> Is this possible? (BTW I don't know how this could work with the
IBX
> components)
>
>
> --- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> > At 08:06 PM 9/2/2002 +0000, supertokkie wrote:
> > >Is it possible to use savepoints in transactions in Interbase
6.0?
> >
> > Yes and no. The database keeps savepoints internally - hence
> > the message "too many savepoints", but the capability is not
> > surfaced.
> >
> > Out of curiosity, how would you use savepoints?
> >
> >
> > Regards,
> >
> > Ann
> > www.ibphoenix.com
> > We have answers.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@e...
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]