Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL UPDATE - Usage
Message
From
27/10/2004 10:24:41
Ravi Taxali
Markham, Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL UPDATE - Usage
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00954866
Message ID:
00954866
Views:
58
I want to use UPDATE command to update in DLWinniners table from TEMP table. The table structure is like this: 
DLWinners:  OrgCode C(5) 
            Code    C(5) 
            more fields...

TEMP        Code    C(5) 
            CodeNew C(5)
If DlWinners.OrgCode is found in TEMP.Code, I want to replace Dlwinners.code with TEMP.CodeNew. I know that this can be done very easily by establishing a relation between two tables. However, is it possible to do this using a single UPDATE command?

Thanks.
- Ravi Taxali
Visual FoxPro Made Simple An excellent book for beginners as well as experienced programmers
Never Forget Again. Setup Email Reminders.
Next
Reply
Map
View

Click here to load this message in the networking platform