UseRowID (ODBCQuery - LotusScript)

Specifies whether data in the back-end database is accessed by row ID.

Defined in

ODBCQuery

Syntax

To get: flag% = odbcQuery . UseRowID

To set: odbcQuery . UseRowID = flag%

Data type

Boolean

Legal values

  • True indicates that "Select by row ID mode" is set.
  • False indicates that "Select by row ID mode" is not set; default.

Usage

UseRowID defaults to False; most databases do not support access by row ID. Set UseRowID to True when you want to use "Select by Row ID mode" (the back-end database must support this type of access). You must set this type of access before using the SQL property to define your SQL statement.

Example