> >
> > Ken,
> > Interpreting it as:
> > "If you don't have buffering you can't use transactions", I would disagree with this statement.
> >
> > Cetin Basoz
>
> Transactions on an buffered tables? Do tell.
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

I'm not sure I understood:) I mean transactions are independant from buffering:

USE (_samples+'data\customer')
BEGIN TRANSACTION
replace ALL region WITH TRIM(region)+'_Updated'
DELETE FOR country = 'USA'
SET DELETED OFF
BROWSE TITLE 'In transaction-deleted' for DELETED()
BROWSE TITLE 'In transaction-updated' FIELDS region,country
ROLLBACK

BROWSE TITLE 'After rollback-deleted' for DELETED()
BROWSE TITLE 'After rollback-updated' FIELDS region,country

USE

Cetin Basoz