Destroys the specified clsD3SelectList object.
object.brCloseSelectList oSelectList
Parameter | Description |
---|---|
object | An object variable that represents a clsD3Connection object. |
oSelectList | An object variable that represents the clsD3SelectList object to be destroyed. |
Attempting to use a clsD3SelectList object that has been closed will result in a run-time error.
Any attempt to close a clsD3SelectList object that has been closed is ignored.
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.brCloseSelectListoList oEnv.brCloseConnection oConn Set oEnv = Nothing End Sub