>UPDATE Ops ; > SET Extno = SPACE(4), ; > LoggedOn = .F. ; > WHERE Extno = app.extno>I don't really care if it's the currently selected table or not. This moves the record pointer for "Ops" to EOF(). My view is that it should not move at all. Otherwise I'd simply use the old SCAN technique
* save recno() here >SCAN FOR Extno = app.extno > REPLACE Extno WITH SPACE(4), LoggedOn WITH .F. >ENDSCAN >*go to old recno hereThis is a guess, but I believe that UPDATE-SQL performs implicit locking and that might be why the pointer moves.