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 NORMAL>>>HTH