brSelect method

For clsD3Connection objects - returns a new clsD3SelectList object containing a list of D3 files from the current account. For clsD3DynamicArray objects - creates a new clsD3SelectList object containing a list of attributes in the clsD3DynamicArray object. For clsD3File objects - returns a new clsD3SelectList object containing a list of item-ids from the D3 file associated with the clsD3File object.

Syntax

Set oSelectList = object.brSelect

Parameters

Parameter	Description
`oSelectList`	An object variable that represents a clsD3SelectList object.
`object`	An object variable that represents an object in the Applies To list.

Remarks

clsD3DynamicArray objects - Use this method with the brReadNext method of clsD3SelectList class to read attribute-by-attribute from a list.

Example

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

Applies to

clsD3Connection class, clsD3Database class, clsD3DynamicArray class, clsD3File class, clsD3NetDomain class, clsD3VirtualMachine class