DBKeyScope property

Applies to
TIB_Connection

Declaration
Property DBKeyScope : TIB_DPBFlag;

Description
This property is used to determine how the DB_KEY scope should be treated for the database connection.

By default, a DB_KEY is only valid for and during a single transaction but it is possible to be able to obtain a DB_KEY and have it remain a valid (in scope) reference to a record by setting this property to true.

Caution should be used when setting this to tru because InterBase internally holds open a transaction for the duration of the connection which will cause the server to be unable to advance the OAT (oldest active transaction). This can lead to an eventual server crash and serious performance degredation. If you use this setting please be sure to cycle connections periodically. I'm not sure how much this matters in low volume update systems but it would be mandatory to avoid these problems in a high volume system.