Reading Data from the Database
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
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.
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.
Call JetCommitTransaction to commit the transaction to the database.