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