Oleg ---
You are going to kick yourself in the butt on this one (lol --- I know, because I've been there), but it's as simple as losing the 'execute' part. Just do:
=SQLEXEC(gnConnHandle,"usp_matchcust")
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05