Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update field
Message
De
04/08/2006 16:23:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Update field
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01143071
Message ID:
01143071
Vues:
53
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform