Reads the next item in the select list associated with the clsD3SelectList object.
bValue = object.brReadNext([ sItemId])
| Parameter | Description |
|---|---|
| bValue | The return value is a Boolean data type that is True if not at the end of the list. |
| object | An object variable that represents a clsD3SelectList object. |
| sItemId | Optional. A Variant (String subtype) containing the item-id resulting from performing this operation. This is an output-only parameter that returns the same results as the brItemId property. |
Sub Main()
Dim oEnv As New clsD3Environment
Dim oConn As clsD3Connection
Dim oList As clsD3SelectList
Dim sItemId As String
Set oConn = oEnv.brOpenConnection("ODBC", "production")
Set oList = oConn.brOpenSelectList("SELECT Customers")
Do While oList.brReadnext(sItemId)
Debug.Print sItemId
Loop
oConn.brCloseSelectList oList
oEnv.brCloseConnection oConn
Set oEnv = Nothing
End Sub