FireDAC.Stan.Option.TFDSecurityOptions.ExactUpdatedRecsNum

From RAD Studio API Documentation
Jump to: navigation, search

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.

See Also