Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Translate sqlserver to vfp command
Message
De
29/09/2005 19:11:58
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows Server 2003
Database:
Visual FoxPro
Divers
Thread ID:
01054718
Message ID:
01054719
Vues:
22
Luis,

>SELECT @ing_fon =SUM(mont2)FROM PLPLFMOV AS MOV JOIN PLPLFTAB AS TAB
>ON mov.concep = tab.concep
>WHERE cod_emple = '092754' AND LEFT(MOV.CONCEP,1)='1' AND SUBSTRING(tab.tab_dscto,1,1) = 'F'

If you want to know how to do this against VFP tables, this part:
@ing_fon =SUM(mont2)
should be
SUM(mont2) AS ing_fon
The rest of it should work just fine in VFP.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform