brValue property

Returns the last item-id read from the select list.

Syntax

sValue = object.brValue

Parameters

Parameter Description
sValue The return value is a String data type.
Object An object variable that represents a clsD3SelectList object.

Remarks

  • The brItemId property is incremented for each call to the brReadnext method.

  • The brItemId property and brValue property return the same results.

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.brValue
      oList.brReadnext
   Loop
 
   oConn.brCloseFile oFile
   oEnv.brCloseConnection oConn
   Set oEnv = Nothing
End Sub