Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update -SQL how to?
Message
From
11/11/2004 09:08:55
Suhas Hegde
Dental Surgeon
Sirsi, India
 
 
To
11/11/2004 08:43:46
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:
00960401
Views:
10
>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
>
still very slow .
about 2,00,000 replacements takes a lot of time
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform