Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Translate sqlserver to vfp command
Message
From
29/09/2005 19:05:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Translate sqlserver to vfp command
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows Server 2003
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01054718
Message ID:
01054718
Views:
49
i want to translate the followng command fo sql server to vfp

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'

how can i do this
thank you
Next
Reply
Map
View

Click here to load this message in the networking platform