Hans,

> with all due respect, I put a little test together using StartTransaction

/

> CommitRetaining / then reissued the Query to refresh and ran this
> simulatenous on two computers. Ttable changes made on one computer, I can
> see after a refresh on the both computers.

True. I bet your transaction isolation is "read committed". Nevertheless,
the transaction on Computer 1 - the one that does CommitRetaining,
isn't ended and can bring you great deals of trouble.

Do a Commit.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com