Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update -SQL how to?
Message
From
12/11/2004 02:17:16
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:
00960703
Views:
11
>
>Like I said, sending your data to me would make no difference. I can see the table structures and what you want to do. You practically answered your own question, to wit:
>
>>update bhav_data.delqty set delqty = del.delqty where bhav_data.symbol = del.symbol and
>>bhav_data.series = del.series and bhav_data.date = del.date
>
>
>update bhav_data ;
>  set delqty = del.delqty ;
>  where bhav_data.symbol = del.symbol ;
>  and   bhav_data.series = del.series ;
>  and   bhav_data.date = del.date
>
>
>Does this do it?
>
>Terry


No it doesnt help. I had tried it and failed.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform