FireDAC.Phys.SQLite.TFDSQLiteSecurity.Options
Delphi
property Options: TFDSQLiteSecurityOptions read FOptions write FOptions default [];
C++
__property TFDSQLiteSecurityOptions Options = {read=FOptions, write=FOptions, default=0};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Phys.SQLite.pas FireDAC.Phys.SQLite.hpp |
FireDAC.Phys.SQLite | TFDSQLiteSecurity |
Description
The encryption options.
Use the Options property to specify the database encryption options.
| Option | Description |
|---|---|
|
soSetLargeCache |
Due to current SQLite encryption limitation the SetPassword / ChangePassword / RemovePassword calls will fail, if the database has blob fields with a value size greater than 1 DB page, and the database does not fit into the SQLite cache. If soSetLargeCache is set, then SetPassword / ChangePassword / RemovePassword automatically set the cache size greater than the DB size, to fit the database into the memory in full. If the DB size is greater than the accessible system memory, then the corresponding call fails. |