I got the recordset with data ( recordcount > 0 ) , but now if
store proc is with Parameters then it's does not work. it gives error.
rs.OPEN(lcSQL,oConn,,,4)
lcSQL is store Proc.
oConn is Connection object
Please any one can help ?
Thanks
Mihir
>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
Previous
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