Cursor position at EOF and BOF

views:

answers:

+1 Q:

Cursor position at EOF and BOF

Where is the Position of cursor in recordset.EOF and recordset.BOF. Any explanation or link info is appreciated much.

+1 A:

Here are some ref:

RC 2010-06-14 04:22:22

@PronekYou may visualize the BOF and EOF positions as follows: If you have a recordset with n rows (starting in row 1, of course), BOF can be understood as position 0, and EOF as position n+1. As the recordset doesn't really have 0 or n+1 rows, BOF and EOF are simply flags: BOF means that there are not any rows before the current position, and EOF means that there are not any rows after the current position.

Barranka 2010-07-09 17:48:41

+1 A:

If you are wondering why, for example, a loop has not exited with movenext when you hit the last record, it is not yet EOF, movenext again and you will hit EOF. The same, of course, applies for the other direction and BOF.

Remou 2010-06-14 07:27:23