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@...]
Sent: Sunday, 8 September 2002 19:20
To: ib-support@yahoogroups.com
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@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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