>>>Seems I am too silly today ;(
>>>The question is:
>>>May I update one table from another without SCAN ? (like localview does it)
>>>
>>>code example
>>>

>>>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
>>>ENDSCAN
>>>

>>>
>>>Maybe it possible to make for one command line? (I do not mean tableupdate and view)
>>>
>>>Sorry for this stupid question
>>>Denis
>>
>>

UPDATE Table1 SET table1.field1 = _tmp.field1 FROM _tmp WHERE table1.id = _tmp.id

>
>
>Hi Vladimir,
>Right.. I thought same ;) but seems I realy silly today... or.... in my case - its update only 1 record in Table1 for current _tmp.id value. Whats wrong?

Denis,
table1 and cursor _tmp has equal number of records.
Is Id field unique? Is so it's normal.
or I misunderstood your question.
Your code

LOCATE FOR table1.id = _tmp.id
IF FOUND()
   replace table1.field1 with _tmp.field1
ENDIF