ADO Stumper

[pjpark]

The following code works in one project but not another:

proc.CommandText = "QryPatientData"
proc.CommandType = adCmdStoredProc
Set proc.ActiveConnection = Me.Connection

proc.Parameters.Refresh
proc.Parameters("@PID&quot.Value = m_lngID

Set rsPat = proc.Execute

The connection string, ActiveX Data objects version, command text, and parameters are the same in both projects. In both projects one record is affected when the sproc is executed. In the second project, the returned recordset is always closed. Why?

Any thoughts?

 

[MurphreeInOK]

make a simple project with only the above code and then add the rest of the code until you get the bug.