Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement