Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update -SQL how to?
Message
From
11/11/2004 08:43:46
 
 
To
11/11/2004 08:12:44
Suhas Hegde
Dental Surgeon
Sirsi, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00960359
Message ID:
00960387
Views:
7
It depends on indexes. You could use this code. You did not specified if symbol + series + date generate a unique key for records in each table.
set talk off
use bhav_data
use del in 2
sele bhav_Data
scan all
   sele del
   locate for symbol=bhav_data.symbol and ;
        series=bhav_data.series and date=bhav_data.date
   if found()
        replace delqty with delqty in bhav_data
   endif
endscan
close data
Mecu Sorin
mecusorin@spymac.com
There is no spoon! Use your hand.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform