Hi

Pl Any one help me, to get record set from SQL server store proc ?

Here is my code...

rs = CREATEOBJECT('ADODB.recordset')
rs.cursorType = 1
rs.OPEN(lcSQL,oConn)

rs is recordset object
oConn is connection object
lcsql is sql server store proc

When it is a simple select statement then it works fine , but when i use
lcSql as some store proc ( store proc has SQL statement and it will return
more than one record )

I do not know what i have to pass in OPEN method OR what to set in
recordset object... that will return me a recordset ( recordcount must be
> 0 )


Thanks
Mihir