>>>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.
>
>Hi Dmitry, can you show me how you return and retrieve the return value from your sp please ? - calling my sp from the vfp command window works a treat but I need it to work from a WinForms app

I thought maybe you wanted to see the VFP code and not .NET code. So, just in case. Here is how the VFP stored procedure returns the value to .NET:

*-- Create an xml string to return.
cRetXml = '<USERINFO>' + chr(13) + ;
	 '<USER_NAME>' + aUserInfo[1] + '</USER_NAME>' + chr(13) + ;
	 '<USER_EMAIL>' + aUserInfo[2] + '</USER_EMAIL>' + chr(13) + ;			 
	 '<USER_CC>' + aUserInfo[3] + '</USER_CC>' + chr(13) + ;
	 '<USER_PHONE>' + aUserInfo[4] + '</USER_PHONE>' + chr(13) + ;			 
	 '<USER_BLDG>' + aUserInfo[5] + '</USER_BLDG>' + chr(13) + ;			 
	 '<USER_FLOOR>' + aUserInfo[6] + '</USER_FLOOR>' + chr(13) + ;			 
	 '<USER_ROOM>' + aUserInfo[7] + '</USER_ROOM>' + chr(13) + ;			 		 	 '</USERINFO>'

RETURN (cRetXml)

HTH