David, Michael-
Personally, I almost never do a REPLACE anymore, but, FWIW, I heard others here suggest that replacing in a table other than is currently selected is best done with IN. As in:
REPLACE TableOrViewName.tLastUpdate with datetime() IN AliasName
Has that been your experience, David?
>You should be able to
REPLACE TableOrViewName.tLastUpdate with datetime() this value won't be committed to the table until you TableUpdate().