FireDAC.Stan.Option.TFDSecurityOptions.ExactUpdatedRecsNum
Delphi
property ExactUpdatedRecsNum: Integer read GetExactUpdatedRecsNum
C++
__property int ExactUpdatedRecsNum = {read=GetExactUpdatedRecsNum, write=SetExactUpdatedRecsNum, stored=IsEURNS, default=-1};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | published | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | TFDSecurityOptions |
Description
The ExactUpdatedRecsNum specifies the maximum number of rows a DML statement can modify.
This property's value is set to -1, which means disabled by default. When it is set to a value greater than zero, then the SQL operation is atomic. So, the full operation is reverted when the number of updated records does not match the specified value.
For example, if you only expect to delete or update one row, you should set the value to 1. The query fails if the number is greater than specified.