MS data application block

mohini · January 28th, 2006, 05:30 AM

I am using sqlhelper.executenonquery and
my stored procedure is returning 2 string values
How should i collect them ??

planoie · February 10th, 2006, 07:37 PM

I'm not familiar with this application block, but generally speaking, how can it be *returning* 2 values? Doesn't the sproc have an OUT parameter?

-Peter

satishkumarj · February 15th, 2006, 02:34 AM

SQL Server Stored Procedure can have More than one Return Parameters not return values.

you need to use the command object variable to get the parameter values

for ex:

if ur Command Object is ObjCom

please refere object properties i am not sure abt syntax but this is the way to get the values
them you need to use like SomeVar = ObjCom("OutputParamName")

HTH

satish

Satish Kumar J