Accessing and updating tables

<< Click to Display Table of Contents >>

Navigation:  Application development > Accessing and updating tables >

Accessing and updating tables

Previous pageReturn to chapter overviewNext page

This table is an overview of the process of accessing and updating tables using Borland Database Engine (BDE):

Phase

Task

BDE function

Preparation

DbiInit

Initialize the database engine

Preparation

DbiOpenDatabase

Open a database

Preparation

DbiOpenTable

Open a table and get a cursor

Preparation

DbiGetCursorProps

Get the cursor properties

Preparation

Responsibility of the application

Allocate the record buffer

Preparation

DbiGetFieldDescs

Retrieve field descriptor information into application-supplied memory

Preparation

DbiBeginDelayedUpdates

Begin cached updates mode

Retrieval

DbiGetNextRecord

Position the cursor and fetch a record into the record buffer

Retrieval

DbiGetField

Retrieve a field from the record buffer

Update

DbiPutField

Update the field and write it to the record buffer

Update

DbiModifyRecord

Update the table with the new record

Update

DbiApplyDelayedUpdates

Apply cached updates to the table

Exit

DbiEndDelayedUpdates

End the cached updates mode

Exit

DbiCloseCursor

Close the cursor

Exit

DbiCloseDatabase

Close the database

Exit

DbiExit

Exit the database engine

 

Also See:

Transactions

Transactions on Paradox, dBASE, FoxPro, and Access