CREATE TABLE Table1 (Id Int,Field1 C(30)) INSERT INTO Table1 VALUES(5 ,"555555555555") INSERT INTO Table1 VALUES(3 ,"333333333333") INSERT INTO Table1 VALUES(2 ,"222222222222") INSERT INTO Table1 VALUES(10,"101010101010") INSERT INTO Table1 VALUES(5 ,"double555555") BROWSE NORMAL select * from table1 into cursor _tmp READWRITE GO TOP LOCATE FOR ID = 3 REPLACE Field1 WITH "update333" GO TOP LOCATE FOR ID = 5 REPLACE Field1 WITH "update555" UPDATE Table1 SET table1.field1 = _tmp.field1 FROM _tmp WHERE table1.id = _tmp.id SELECT Table1 BROWSE NORMALHTH