If you call several times to the method nextCursor when already it is EOF and then it is called to the method previusCursor a mistake is produced. I think that whe Cursor is EOF or position is 0, don't execute the next code:
Public Sub nextCursor()
m_rowNum += 1
If m_rowNum <= m_rs.ResultSet.Tables(0).Rows.Count - 1 Then
m_row = m_rs.ResultSet.Tables(0).Rows(m_rowNum)
m_eof = False
m_bof = False
Else
m_row = Nothing
m_eof = True
End If
End Sub
if I am executed nextCursor, the m_rowNum += 1 always sum and if Cursor is EOF, m_rowNum continues sum and if i execute previosCursor, it is mistake, because the m_rowNum don't is correctly.
Saludos
Victor (Madrid - Spain)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you call several times to the method nextCursor when already it is EOF and then it is called to the method previusCursor a mistake is produced. I think that whe Cursor is EOF or position is 0, don't execute the next code:
Public Sub nextCursor()
m_rowNum += 1
If m_rowNum <= m_rs.ResultSet.Tables(0).Rows.Count - 1 Then
m_row = m_rs.ResultSet.Tables(0).Rows(m_rowNum)
m_eof = False
m_bof = False
Else
m_row = Nothing
m_eof = True
End If
End Sub
if I am executed nextCursor, the m_rowNum += 1 always sum and if Cursor is EOF, m_rowNum continues sum and if i execute previosCursor, it is mistake, because the m_rowNum don't is correctly.
Saludos
Victor (Madrid - Spain)
Thanks for pointing that out. I'll make some changes soon and commit a fix.
- Richard
The changes are now done and CVS has been updated.