Vista - How can a Record type be returned by a stored procedure?

Hi All,

I want to know, if i can define a recordType in the
createParameter().
Currently i am using the following code
.Parameters.Append .CreateParameter("date_diff_days", 3, 1)
3- is for Integer,

I would like to know if there is a number for recordType? How can i
fetch the record that is returned by the stored procedure?

Thanks
Deepal

deepal.82@xxxxxx wrote:What database? Type and version please.

In SQL Server, there is no "Record" type. You have to use a SELECT statement
to return a resultset.
I suppose you could return xml in an output parameter ....

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"