crpav
Posts: 3
|
| Posted: 10/30/2004, 5:13 PM |
|
I am trying to read a recordset from a stored procedure,
but these code doesn't work :
Dim SQL, cnx, rs, msgerr
SQL = "SP_NEXTISSUE " & CStr( Issues.Proy_id.value )
set cnx = new clsDBConnection1
cnx.Open
set rs = cnx.Execute( SQL )
if NOT rs.EOF then
Issues.Seq_id.value = rs(0)
Issues.Reference.value = rs(1)
end if
cnx.close
set cnx = Nothing
This error is displayed:
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
Can anyone give me some advice ?
Thank you !
|
 |
 |
|
