brItemId property

Returns the last item-id referenced by the object.

Syntax

sValue = object.brItemId

Parameters

Parameter	Description
`sValue`	The return value is a String data type.
`object`	An object variable that represents an object in the Applies To list.

Remarks

clsD3File objects – returns the item-id of the item most recently referenced by the following methods: brDelete, brRead, brReadU, brReadV, brReadVU, brRelease, brWrite, brWriteU, brWriteV, brWriteVU.

clsD3SelectList objects – returns the item-id of the item read by the most recent call to brReadnext.

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

Applies to