General information
Title:
SQL server stored procedure from VFP
here is my problem:
1) stored proc usp_MatchCust works fine from ISQL (it does updates):
execute usp_MatchCust "11/01/1998","11/02/1998"
2) from Fox:
= SQLEXEC (gnConnHandle,"execute usp_MatchCust ?lcDate1,?lcDate2")
Does nothing, returns -1
= SQLEXEC (gnConnHandle,;
'execute usp_MatchCust "11/01/1998","11/02/1998"')
Checked parameters, tried constants, ... nothing helped
3) tried proc without parameters, still does not work :
= SQLEXEC (gnConnHandle,"execute test")
Connection is OK, select or update without stored proc works fine.
What I am missing?
TIA
Oleg
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only