Reading Data from the Database

Windows

Last modified: January 09, 2012

Applies to: Windows | Windows Server

Reading data from the database should be performed within a transaction.

The following procedure shows how to perform a simple read operation in the database.

To read data from a database

  1. Call JetBeginTransaction or JetBeginTransaction2 with the session ID to start the transaction.

  2. Move the cursor to the desired record by calling JetMove with JET_MoveFirst in the cRow parameter. For more information on how to move the cursor, see the Indexing in the Table topic.

  3. Call JetGetTableColumnInfo on the current record with JET_ColInfo specified in the InfoLevel parameter to retrieve the column ID for the column. The column ID is returned in the JET_COLUMNDEF structure.

  4. Read the data from the column by calling JetRetrieveColumn with the column ID retrieved in step 3 in the columnid parameter. The pvData parameter contains the type of data specified in the JET_COLUMNDEF structure retrieved in step 3.

  5. Call JetCommitTransaction to commit the transaction to the database.

Show: