>>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
>
>Yes.. and in your example ID = 3 .. stay as is "333333333333" and not updated with "update333".. it was exactly my quesstion
Denis,
look at second browse
My result is:
5 update555
3 update333
2 222222222222
10 101010101010
5 update555This result is with VFP9 SP1.
_______________________________________________________________
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
