Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 6/7 doesn't support from clause in SQL ?
Message
De
01/11/2002 12:34:23
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
01/11/2002 12:27:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00717899
Message ID:
00717905
Vues:
17
>I am writing a T-SQL stored procedure that uses the FROM clause in an update statement. I wanted to test the equivalent functionality in VFP. But then I looked at the VFP help and realized that it does not appear to be supported in vfp 6 or 7. How about in 8?
>
>How can I update rows in one table in vfp based upon a join condition on two tables?
>
>TIA

Unfortunately it doesn't :( And AFAIK not in VFP8 either (but added to insert-SQL). First do SQL for joined tables then update (probably with scan..endscan)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform