My reason for not wanting to use begin and commit transactions is that I
have several forms open at one time, possibly all with pending transactions.
If I use commit transactions, all will be commited. By using cached updates
one forms records at a time can be saved.

Any ideas would be appreciated.

Another thing: transactions are local to the connection, so if you need
multiple transactions, use multiple TDatabase objects.
Some servers support sub-transactions (savepoints), so you can use them
instead of multiple transactions - naturally depends on transaction type.

You'll also have to consider record locking and transaction isolation
level....
--
-------------------------
Regards,
Robert