|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
I have a recordset with at least one record in it, it is triggering an 'EOF or BOF is True' error when using .MovePrevious or .MoveNext.
Putting the IDE in break mode and analising the values of EOF and BOF in the Immediate Window show them both to be True. There are records in the recordset and I have confirmed this by analising the Database file directly. How can BOF and EOF both show True other than when the RecordSet of Empty? I am using ADO with the Jet Engine 3.41. Please help, I can't figure out what is going on. |
|
#2
|
||||
|
||||
|
I'm not sure I understand how you know that the recordset has values in it. The Database table might have records, but that is not conclusive that those records are getting into the recordset. How are you actually examining the recordset for the existence of data? Can you post some code?
__________________
Fisherman "Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein |
|
#3
|
|||
|
|||
|
Use the debugger to look in the recordset. The only way bof and eof are both true is when the recordset is empty (ADO).
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Recordset BOF & EOF both True thou' Recordset contains records |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|