select * from table1 into cursor _tmp READWRITE Then I modify one field in _tmp cursor .. and then I want to update Table1 with new modifications.. SELECT _tmp SCAN ALL SELECT table1 LOCATE FOR table1.id = _tmp.id IF FOUND() replace table1.field1 with _tmp.field1 ENDIF SELECT _tmp ENDSCANMaybe it possible to make for one command line? (I do not mean tableupdate and view)