IDLdbRecordset Properties

IDL DataMiner Guide: IDL DataMiner API

IDLdbRecordset Properties

IDLdbRecordset objects have the following properties in addition to properties inherited from any superclasses. Properties with the word "Yes" in the "Get" column of the property table can be retrieved via IDLdbRecordset::GetProperty. There are no Init or SetProperty methods for the IDLdbRecordset object.

Note
For a discussion of the property description tables shown below, see About Object Property Descriptions.

CAN_MOVE_ABSOLUTE

If True, the cursor for the recordset can move to an absolute record number.


Property Type	Boolean
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

CAN_MOVE_FIRST

If True, the cursor for the recordset can move to the first record.


Property Type	Boolean
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

CAN_MOVE_LAST

If True, the cursor for the recordset can move to the last record.


Property Type	Boolean
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

CAN_MOVE_NEXT

If True, the cursor for the recordset can move to the next record.


Property Type	Boolean
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

CAN_MOVE_PRIOR

If True, the cursor for the recordset can move to the previous record.


Property Type	Boolean
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

CAN_MOVE_RELATIVE

If True, the cursor for the recordset can move to a record number relative to the current record number.


Property Type	Boolean
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

FIELD_INFO

An array of field informational structures, one for each field in the result set. Field information is only available if the current recordset was generated from a table (that is, if the TABLE property was set when creating the recordset object). Information structures have the following fields (see the ODBC Manual for more information):

TABLE_QUALIFIER: The table qualifier.

TABLE_OWNER: The name of the table owner.

TABLE_NAME: The name of the table.

FIELD_NAME: The name of the field.

TYPE_NAME: The datasource type name.

PRECISION: Precision of the field.

LENGTH: Length in bytes of the data.

SCALE: The scale of the field.

IS_NULLABLE: The field can contain null values.

IS_AUTOINCREMENT: The field is an autoincrement field.

IS_CASE_SENSITIVE: The value of the field is case sensitive.

IS_UPDATABLE: The field can be updated.

IDL_TYPE: The IDL type to which the field is mapped.

If a field is returned empty, this indicates that the driver doesn't support the query for that particular information.


Property Type	Array of structures
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

GET_DATABASE

An object reference to the database object used when the current recordset object was created.


Property Type	Object reference
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

IS_READONLY

If True, the table is read-only.


Property Type	Boolean
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

N_BUFFERS

The number of buffers allocated for the recordset.


Property Type	Integer
Name String	not displayed
Get: Yes	Set: No	Init: Yes	Registered: No

RECORDSET_SOURCE

A string containing either the table name or SQL statement used to create the recordset.


Property Type	String
Name String	not displayed
Get: Yes	Set: No	Init: No	Registered: No

IDL Online Help (March 06, 2007)