Applies to: Windows | Windows Server
Reading Data from the Database
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 JetBeginTransaction or JetBeginTransaction2 with the session ID to start the transaction.
-
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.
-
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.
Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.
