Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update field
Message
From
04/08/2006 16:23:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Update field
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01143071
Message ID:
01143071
Views:
55
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
Next
Reply
Map
View

Click here to load this message in the networking platform