Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADAutoIncField.IdentityInsert Property
TADAutoIncField Class  TADAutoIncField Members  uADCompDataSet Namespace  Example  published  See Also  Send Feedback

Enables to explicitly assign values to the auto incremental column.

Group

published

Links
TADAutoIncField Class, TADAutoIncField Members, uADCompDataSet Namespace, Example, published, See Also
Description

Set IdentityInsert property to True to enable explicit assignment of a value to the auto incremental column. By default it is False. Note, that not all DBMS's support assignment of a value to the identity column. 

When a DBMS supports sequences or generators, and application uses client side field value filling from a sequence, then it is required to set IdentityInsert to True.

Syntax
property IdentityInsert: Boolean;
See Also
Example
TADAutoIncField(ADQuery1.Fields[0]).IdentityInsert := True;
ADQuery1.Append;
ADQuery1.Fields[0].Value := 123;
ADQuery1.Post;
What do you think about this topic? Send feedback!