rs.BOF and rs.EOF

[mp3909]

I am seeking some clarification.



does rs.EOF mean the end of recordset or last record of a recordset?

and does rs.BOF mean before the first record of a recordset or the first record of a recordset?

[isladogs]

Just out of interest, what do you think there is in a recordset before the first record or after the last record?

[ranman256]

End of File is the last record. You get an error if you go past it.

Begin of File is 1st, you get an error if you try to go before it.

[ArviLaanemets]

https://docs.microsoft.com/en-us/sql...ql-server-2017

BOF Indicates that the current record position is before the first record in a Recordset object.
EOF Indicates that the current record position is after the last record in a Recordset object.

...
The BOF property returns True (-1) if the current record position is before the first record and False (0) if the current record position is on or after the first record.
The EOF property returns True if the current record position is after the last record and False if the current record position is on or before the last record.

Quoted allows the check for empty recordest. When EOF = BOF, then recordset is empty.

[accesstos]

Just out of interest, what do you think there is in a recordset before the first record or after the last record?

The same as before the birth and after the death: A universe of possibilities to exist.

[isladogs]

Ah...that allows for an infinite number of possible answers