Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update -SQL how to?
Message
De
12/11/2004 02:17:16
Suhas Hegde
Dental Surgeon
Sirsi, Inde
 
 
À
11/11/2004 10:04:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Divers
Thread ID:
00960359
Message ID:
00960703
Vues:
12
>
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform