Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Translate sqlserver to vfp command
Message
From
29/09/2005 19:11:58
 
 
To
29/09/2005 19:05:04
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows Server 2003
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01054718
Message ID:
01054719
Views:
21
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
Previous
Reply
Map
View

Click here to load this message in the networking platform