Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View not updating data
Message
De
09/08/2006 22:04:55
Aaron K. Y. Chu
Health & Care Co. Ltd.
Hong Kong, Hong Kong
 
 
À
09/08/2006 21:37:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01143996
Message ID:
01144379
Vues:
24
I think if you're still having the problem... to make things simple, you can update the tables separately, & then doing the SQL statement...

OR you can use SQL statement to do the update as follows: (of course, you could do it with insert)
lcdate = ??
lcgang = ??
lcBlock = ??
lnripe = ??
lngreen = ??

update a set a.ddate=lcdate, a.cgang=lcgang, a.cblock=lcBlock, b.nripe=lnripe, b.ngreen=lngreen from dailyWork a inner join ;
pkg b on a.ncode=b.ncode where a.copr = ("PKG") order by a.ddate
Best regards,

Aaron Chu

********************************************************

Working with Visual FoxPro is a lot of FUN!

********************************************************
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform