See if this message Re: Locking VFP records in ASP.NET Thread #1348296 Message #1348362 can work for you.

>Hi, i have a program in C# .Net calling a store procedure in dbc, it works fine but i have 1 parameter that must be filled in that procedure then C# knows about that value.
>

>procedure getpages
>lparameters csql,npag
>local nmaxreg=10
>execscript(csql)
>npag=_tally/nmaxreg
>return setresultset("query")
>endproc 
>

>I need that npag returns to C# with the value calculated here. Is it possible? T.I.A.