AnyDAC
ContentsIndexHome
PreviousUpNext
TADAutoIncField.ClientAutoIncrement Property

Specifies when dataset need to generate auto incremental value for new record column.

Group
Links

Set ClientAutoIncrement property to True (default value) and dataset will generate auto incrementing value for new record column. 

The dataset uses internal auto increment value generator. The initial value is equal to AutoIncrementSeed. The value is incrementing for new record by AutoIncrementStep. After dataset is closed, the internal auto increment value generator is reset to AutoIncrementSeed

This may be usefull in CachedUpdates = True mode.

property ClientAutoIncrement: Boolean;
ADQuery1.CachedUpdates := True;
ADQuery1.Open;
ADQuery1.Append;
....
ADQuery1.Post;
// TADAutoIncField(ADQuery1.Fields[0]).Value -> -1
ADQuery1.Append;
....
ADQuery1.Post;
// TADAutoIncField(ADQuery1.Fields[0]).Value -> -2
ADQuery1.Append;
....
ADQuery1.Post;
// TADAutoIncField(ADQuery1.Fields[0]).Value -> -3
ADQuery1.ApplyUpdates;
What do you think about this topic? Send feedback!