In that case the CLOB data will not be read, just the record data. But I see your point. Why should you fetch all columns when only a few need to be compared. The roAllFields option of the RefreshOptions causes these refresh, compare and some lock operations to re-execute the original SQL statement, with the where clause extended with the rowid. Unfortunately this does not affect the lock operation for a delete. I will add this to the enhancement requests.
------------------
Marco Kalter
Allround Automations