General information
Title:
Record set from SQL server Store Proc
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only