>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,
probably it is something like this, but not exactly...
In fact I added "execute" after simple "usp_matchcust" failed.
So I tried
=SQLEXEC(gnConnHandle,"usp_matchcust")
and
=SQLEXEC(gnConnHandle,"test")
Still does not work.
Will delay kicking for while.
Thanks,
Oleg