Returns a value that indicates whether the current position is after the last element in the list.
bValue = object.brEOL
| Parameter | Description |
|---|---|
| bValue | The return value is a Boolean that is True if the current position is after the last element in the list, and False if the current position is on or before the last element in the list. |
| object | An object variable that represents a clsD3SelectList object. |
If both brBOL and brEOL return True, then the clsD3SelectList object is in an uninitialized state. The brBOL and brEOL properties are not valid until after the first brReadnext.
Sub Main()
Dim oEnv As New clsD3Environment
Dim oConn As clsD3Connection
Dim oFile As clsD3File
Dim oList As clsD3SelectList
Dim sItemId As String
Set oConn = oEnv.brOpenConnection("ODBC", "production")
Set oFile = oConn.brOpenFile("sqldemo,customers,")
Set oList = oFile.brSelect
oList.brReadnext
Do Until oList.brEOL
Debug.Print oList.brItemId
oList.brReadnext
Loop
oConn.brCloseFile oFile
oEnv.brCloseConnection oConn
Set oEnv = Nothing
End Sub