Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View not updating data
Message
From
09/08/2006 22:04:55
Aaron K. Y. Chu
Health & Care Co. Ltd.
Hong Kong, Hong Kong
 
 
To
09/08/2006 21:37:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01143996
Message ID:
01144379
Views:
15
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!

********************************************************
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform