Try this
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
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
