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.