Connecting to a Table

IDL DataMiner Guide: Using the IDL DataMiner

Connecting to a Table

Connecting to a table and retrieving its data involves:

creating a Recordset object,

specifying the table from which the information is being retrieved.

The recordset object contains a database table or a selection based on criteria you specify in an SQL query. This object allows you to programmatically manipulate the data in the database. To create this object, a valid database object is required.

In the following example, a new Recordset object is being created for a table called "mydata."

objRS = OBJ_NEW('IDLDBRecordset', objDB, table='mydata')

Once you have connected to a table, you can use IDL DataMiner methods to manipulate the data in several ways as depicted in the examples provided in the next section.

Note
When a table is selected, the entire data contained in the table is not automatically imported into IDL. This preserves memory. You can retrieve the desired data in a recordset by moving the cursor to the desired record via the MoveCursor method and then importing that data into IDL using the GetField or GetRecord method.

IDL Online Help (March 06, 2007)