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