FireDAC.Stan.Option.TFDFetchOptions.DetailServerCascade
Delphi
property DetailServerCascade: Boolean read GetDetailServerCascade write SetDetailServerCascade stored IsSDCS default False;
C++
__property bool DetailServerCascade = {read=GetDetailServerCascade, write=SetDetailServerCascade, stored=IsSDCS, default=0};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | TFDFetchOptions |
Description
Specifies when a DB detail table foreign key has an update / delete cascade option.
When DetailServerCascade is True, then FireDAC does not post client-side cascading changes to a database, because it expects that those changes were performed by the database.
When DetailServerCascade is False, then FireDAC posts client-side cascading changes to the database. The client-side cascading changes are performed when DetailCascade is True. So DetailServerCascade should be used together with DetailCascade.
When DetailServerCascade is True, then after a client-side cascading update, you:
- Cannot undo cascading changes to a detail dataset
- Cannot get the original value of cascade updated fields. TField.OldValue is equal to TField.CurValue / Value.