>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham