Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE not working
Message
 
 
To
27/08/2008 15:49:15
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01342335
Message ID:
01342338
Views:
18
>What is wrong with this? It replaces all the dates in covr with the same one, probably the first one in the patient table. I can do this in multiple lines with RELATION, but I need it to be one line.

Use UPDATE FROM

>
update covr set covr.ph_dob = patient.ptdob from Covr INNER 
JOIN Patient ON ALLTRIM(covr.pat_no) = ALLTRIM(patient.ptpn)
Also do we need ALLTRIM() ?

Recent thread with the similar question on another forum

http://tek-tips.com/viewthread.cfm?qid=1496541
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform