Data.Win.ADODB.TAutoIncFieldsMode

From RAD Studio API Documentation
Jump to: navigation, search

[–] Properties
Type: enum
Visibility: public
Source:
Data.Win.ADODB.pas
Data.Win.ADODB.hpp
Unit: Data.Win.ADODB
Parent: Data.Win.ADODB

Delphi

TAutoIncFieldsMode = (
afAll,
afFirst,
afNone);

C++

enum DECLSPEC_DENUM TAutoIncFieldsMode : unsigned char { afAll, afFirst, afNone };

Description

TAutoIncFieldsMode is an auto incremental fields detection mode that optimizes dataset time.

Some OLEDB providers, like SQL Server one, exchange additional data packets with a DB server to detect if a field is an auto-incrementing one. On a large SELECT list, this may affect performance critically.

TAutoIncFieldsMode items are

  • afAll - try to detect if any field is an auto-increment field or not.
  • afFirst - stop the detection of auto-increment fields after the first one is found.
  • afNone - do not detect auto-increment fields.