brCloseSelectList method

Destroys the specified clsD3SelectList object.

Syntax

object.brCloseSelectList oSelectList

Parameters

Parameter Description
object An object variable that represents a clsD3Connection object.
oSelectList An object variable that represents the clsD3SelectList object to be destroyed.

Remarks

  • 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.

Example

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