>i want to call a sqlserver procedure that make a calculation and send back the result to vpf. how to do it?
What result?
Is it a result set or just some value?
Both ways you could use a SELECT to generate VFP cursor:
? SQLEXEC(sqlHandler, "EXEC MySP","MyCursor")
BROWSE NORMAL
--- SQL Server SP MySP
SELECT * FROM SomeTable ...
--- Other version
DECLARE @SomeNumb number(10,2)
DECLARE @OtherNumb number(10,2)
SET @SomeNumb = 123
SET @OtherNumb = 12
SELECT @SomeNumb/@OtherNumb
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.