>I am updating 1050 rcords in a table buffered view...
>

James, I don't think this situation calls for a buffered update. Consider this code:

scan for iForeign_key <> 100
replace iForeign_key with 100
endscan

Run this in the default data session (no buffering) with an error trap. If it doesn't finish properly, then just run it again. You don't need to ROLLBACK.

Peter Robinson