recordcount not working......
Posted on 2002-05-24
i am using a stored procedure to "fill" a recordset but the recordset.recordcount = 0 doesnt seems to work at all!
anyone can point me into the right direction?
sqlstr = "up_Top_ABCD '" & period8 & "' "
Set rsInvDetailStatus = New ADODB.Recordset
.CursorLocation = adUseServer
.Open sql66, frmMainMenu.db, adOpenKeyset, adLockBatchOptimistic, adCmdText
If rsInvDetailStatus.RecordCount = 0 Then
errmsg = MsgBox("No matching records found!", vbCritical, "No records found")
Set rsInvDetailStatus.ActiveConnection = Nothing
msgbox "have records"