Newbie:there's 2 bof&eof?

Newbie:there's 2 bof&eof?

Post by Han » Mon, 28 May 2001 23:16:08



I have recordsets returning from adodc object and put them on grid.
When i call moveprevious after movefirst the cursor on the grid disappear ( same
with movenext after movelast )
if i check the bof or eof two times then it will work. any idea? or better idea?
sampe : in cmd_click event
                        --> if rs.bof then
                               rs.movelast
                            else
                               rs.moveprevious
                            end if
                            if rs.bof then
                               rs.movelast
                            end if
 
 
 

1. BOF & EOF

In reading MS's documentation BOF=EOF=True means there are no records
(using VB6, DAO 3.51).  Why then would they both be true with a record?
I am trying to count the records, which means I have to use MoveFirst
MoveLast, but can't if both BOF and EOF are true.  Is there an easier
way to get the count?  MS's tools are not so great.

Dennis,

2. GA-ATLANTA-73430--ORACLE-SQL *Net-SQL-UNIX Production Support

3. Q&A 4.0?

4. My database program is creating temp files on the desktop!?!

5. MSHFlex.recordset = rs & EOF/BOF markers

6. how do I list tables in a database?

7. Either BOF or EOF...

8. Error: BOF or EOF is TRUE, HELP!

9. Browsing thru records without clicking error at BOF and EOF

10. What code to recognise EOF, BOF?

11. Error 3021 "Either EOF or BOF, record may be deleted