Working with Table Data

IDL DataMiner Guide: Using the IDL DataMiner

Working with Table Data

Once you have created the Recordset object and connected to a table, you can use IDL DataMiner methods to retrieve and manipulate the data in several ways. For example, you can:

find out if a table is "ReadOnly",

get properties of the recordset,

move the cursor,

add records,

delete records,

retrieve fields,

set fields,

find the current row number in a recordset,

find the number of fields in a recordset,

get an array of field information structures, one for each field in the recordset.

You can also obtain information about a database or recordset concerning the following:

the number of table fields,

the name of DBMS associated with a database object,

the DBMS version,

a list of available drivers,

the ODBC driver level,

the ODBC driver version,

the maximum number of connections.

Moving Through a Recordset

Moving through recordsets is based on the concept of the cursor. The cursor is the current row, or record, in the recordset. When you refer to fields in a Recordset, you obtain values from the current record, and only the current record can be modified.

You can use the Recordset object's MoveCursor method to navigate through the records in a recordset. Keywords to the MoveCursor method allow you to specify new cursor locations.

In the following example, the MoveCursor method and FIRST keyword move to the first record.

status = objRS->MoveCursor(/FIRST)

In the following example, the MoveCursor method and NEXT keyword move to the next record.

status = objRS->MoveCursor(/NEXT)

IDL Online Help (March 06, 2007)