server stored procedure:
sConn = "Provider='SQLOLEDB';Data Source='Aph-Ework-Dev';" & _
"Initial Catalog='NB2KunsecuredSQL';Integrated
Security='SSPI';"
oConn.Open sConn
'Set up command to get list of required shifts
oCmdTmpShift.CommandText = "qslGetShiftsTMP"
oCmdTmpShift.CommandType = adCmdStoredProc
Set oCmdTmpShift.ActiveConnection = oConn
With oCmdTmpShift
.Parameters("@Ward") = Forms!frmBookNurse!strWard
.Parameters("@ShiftDate") = Me!dtmDateAvailable
.Parameters("@Shift") = Me!strShiftAvailable
.Parameters("@Enhanced") =
Forms![frmBookNurse]![ChkEnhanced]
.Parameters("@Grade") = Me!strGrade
'.Execute
Set oRSShift = New ADODB.Recordset
oRSShift.CursorType = adOpenStatic
oRSShift.LockType = adLockReadOnly
oRSShift.Open oCmdTmpShift
End With
THe problem is the cursor type is always forward only - not static as I
specified. This means that I can't get a recordcount or use
movefirst/movelast.
From what I have read this should be possible - What am I doing wrong?