|
Subject:
|
MS data application block
|
|
Posted By:
|
mohini
|
Post Date:
|
1/28/2006 4:30:30 AM
|
I am using sqlhelper.executenonquery and
my stored procedure is returning 2 string values
How should i collect them ??
|
|
Reply By:
|
planoie
|
Reply Date:
|
2/10/2006 6:37:25 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
|
|
Reply By:
|
satishkumarj
|
Reply Date:
|
2/15/2006 1:34:35 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
|
