FireDAC.Comp.Script.TFDScriptOptions.CommitEachNCommands
Delphi
property CommitEachNCommands: Integer read FCommitEachNCommands write FCommitEachNCommands default 0;
C++
__property int CommitEachNCommands = {read=FCommitEachNCommands, write=FCommitEachNCommands, default=0};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Comp.Script.pas FireDAC.Comp.Script.hpp |
FireDAC.Comp.Script | TFDScriptOptions |
Description
Specifies the number of SQL commands after which a COMMIT must be performed.
Set the CommitEachNCommands property to the number of SQL commands, after which the script engine performs the command COMMIT. Set this property to 0 to enable the auto-commit mode, where each SQL command is committed. The default value is 0.
The property can be set from a script using the SET AUTOCOMMIT N command.