>>Hi all, I'm trying to return a value from a VFP sp to my .NET app without success my sp is shown below
>>
>>
>>proc UpdateName
>>Lparameters Name,ID
>>
>>Update MyTable ;
>>set MyName = Name where MyID = ID
>>
>>Return _tally
>>
>>EndProc
>>
>>
>>
>>I'm using a Command.ExecuteNonQuery() statement which is supposed to return the number of records affected by the query but always returns 1. If I remove the return statement it makes no difference at all.
>
>I usually return a string (an XML string) from my VFP sp when calling it from ASP.NET. And it works. Maybe you could try convert the value you are trying to return into a char type.
>
>HTH.
Thanks I'll give it a try when I'm back at work
Regards,
Peter J. Kane
Pete