>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.
I haven't tried, but can you use ParameterDirection as shown here
http://msdn.microsoft.com/en-us/library/59x02y99.aspx ? I would assume it may work with OleDb.
If it's not broken, fix it until it is.
My Blog