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.