Data.Win.ADODB.TAutoIncFieldsMode
Delphi
TAutoIncFieldsMode = (
afAll,
afFirst,
afNone);
C++
enum DECLSPEC_DENUM TAutoIncFieldsMode : unsigned char { afAll, afFirst, afNone };
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| enum | public | Data.Win.ADODB.pas Data.Win.ADODB.hpp |
Data.Win.ADODB | Data.Win.ADODB |
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.