Class TSqlitePassDatabaseOptions

DescriptionHierarchyFieldsMethodsProperties

Unit

Declaration

type TSqlitePassDatabaseOptions = class(TPersistent)

Description

TSqlitePassDatabaseOptions

Hierarchy

Overview

Methods

Public constructor Create(Database: TSqlitePassDatabase);
Public destructor Destroy; override;
Public Function GetEncodingAsString(Encoding: TSqlitePassEncoding): String;
Public Procedure Apply;

Properties

Published property ApplyMode: TSqlitePassApplyModes Read FApplyMode Write FApplyMode;
Published property AutoVacuum: TSqlitePassAutoVacuumType Read GetFAutoVacuum Write SetFAutoVacuum;
Published property CacheSize: Integer Read GetFCacheSize Write SetFCacheSize;
Published property CaseSensitiveLike: Boolean Read FCaseSensitiveLike Write SetFCaseSensitiveLike;
Published property CountChanges: Boolean Read GetFCountChanges Write SetFCountChanges;
Published property DefaultCacheSize: Integer Read GetFDefaultCacheSize Write SetFDefaultCacheSize;
Published property Encoding: TSqlitePassEncoding Read GetFEncoding Write SetFEncoding;
Published property ForeignKeys: Boolean Read GetFForeignKeys Write SetFForeignKeys;
Published property FullColumnNames: Boolean Read GetFFullColumnNames Write SetFFullColumnNames;
Published property JournalMode: TSqlitePassJournalMode Read GetFJournalMode Write SetFJournalMode;
Published property JournalSizeLimit: Integer Read GetFJournalSizeLimit Write SetFJournalSizeLimit;
Published property LockingMode: TSqlitePassLockingMode Read GetFLockingMode Write SetFLockingMode;
Published property LogErrors: Boolean Read FLogErrors Write FLogErrors;
Published property MaxPageCount: Integer Read GetFMaxPageCount Write SetFMaxPageCount;
Published property PageSize: TSqlitePassPageSize Read GetFPageSize Write SetFPageSize;
Published property QuoteStyle: TSqlitePassQuoteStyle Read FQuoteStyle Write SetFQuoteStyle;
Published property RecursiveTriggers: Boolean Read GetFRecursiveTriggers Write SetFRecursiveTriggers;
Published property SecureDelete: Boolean Read GetFSecureDelete Write SetFSecureDelete;
Published property Synchronous: TSqlitePassSynchronous Read GetFSynchronous Write SetFSynchronous;
Published property TemporaryStorage: TSqlitePassTempStore Read GetFTemporaryStorage Write SetFTemporaryStorage;
Published property TemporaryStorageDir: String Read GetFTemporaryStorageDir Write SetFTemporaryStorageDir;

Description

Methods

Public constructor Create(Database: TSqlitePassDatabase);
 
Public destructor Destroy; override;
 
Public Function GetEncodingAsString(Encoding: TSqlitePassEncoding): String;
 
Public Procedure Apply;

Writes the options settings to the database file

Properties

Published property ApplyMode: TSqlitePassApplyModes Read FApplyMode Write FApplyMode;

This property sets how the options are applied to the database file.
When database is already connected, any options change is directly applied to the database file.
When database is not connected, the changes are only applied when you open the database (Connected = True), depending on the ApplyMode setting : if amOverwriteDatabaseFileSettings is True, then the the ApplyMode selected options are applied to the database file with the values defined in object inspector (designtime) or in your *.dfm or *.lfm file (runtime).
if amOverwriteDatabaseFileSettings is False, your customized settings will discarded and overwritten with the current database file settings.

Published property AutoVacuum: TSqlitePassAutoVacuumType Read GetFAutoVacuum Write SetFAutoVacuum;

This property gets or sets the database autovacum pragma as described in the Sqlite help

Published property CacheSize: Integer Read GetFCacheSize Write SetFCacheSize;

This property gets or sets the database CacheSize pragma as described in the Sqlite help

Published property CaseSensitiveLike: Boolean Read FCaseSensitiveLike Write SetFCaseSensitiveLike;

This property gets or sets the database CaseSensitiveLike pragma as described in the Sqlite help

Published property CountChanges: Boolean Read GetFCountChanges Write SetFCountChanges;

This property gets or sets the database CountChanges pragma as described in the Sqlite help

Published property DefaultCacheSize: Integer Read GetFDefaultCacheSize Write SetFDefaultCacheSize;

This property gets or sets the database DefaultCacheSize pragma as described in the Sqlite help

Published property Encoding: TSqlitePassEncoding Read GetFEncoding Write SetFEncoding;

This property is readonly =. It gets the database Encoding as described in the Sqlite help - the database encoding can only be set if the database has not already been created

Published property ForeignKeys: Boolean Read GetFForeignKeys Write SetFForeignKeys;

This property gets or sets the database FullColumnNames pragma as described in the Sqlite help

Published property FullColumnNames: Boolean Read GetFFullColumnNames Write SetFFullColumnNames;

This property gets or sets the database FullColumnNames pragma as described in the Sqlite help

Published property JournalMode: TSqlitePassJournalMode Read GetFJournalMode Write SetFJournalMode;

This property gets or sets the database Journal mode pragma as described in the Sqlite help

Published property JournalSizeLimit: Integer Read GetFJournalSizeLimit Write SetFJournalSizeLimit;

This property gets or sets the database Journal mode property as described in the Sqlite help

Published property LockingMode: TSqlitePassLockingMode Read GetFLockingMode Write SetFLockingMode;

This property gets or sets the database Journal mode pragma as described in the Sqlite help

Published property LogErrors: Boolean Read FLogErrors Write FLogErrors;

When set to True, Errors are logged to the TSqlitePassDatabase.DatabaseError.ErrorList

Published property MaxPageCount: Integer Read GetFMaxPageCount Write SetFMaxPageCount;

This property gets or sets the Maximum database Pages Count pragma as described in the Sqlite help

Published property PageSize: TSqlitePassPageSize Read GetFPageSize Write SetFPageSize;

This property gets or sets the database PageSize pragma as described in the Sqlite help

Published property QuoteStyle: TSqlitePassQuoteStyle Read FQuoteStyle Write SetFQuoteStyle;

This property gets or sets the database default quote style used to surround identifiers in sql statements. It can take one of the following values :

  • qsDoubleQuote for "

  • qsBracket for [ and ]

  • sqGraveQuote for `



Note : the different parts of a database item identifier must be surrounded separatly in the SQL statement :
for example, Select [TableName].[FieldName] from [TableName]; is a valid statement Select "TableName"."FieldName" from "TableName"; is a valid statement
Select [TableName.FieldName] from [TableName]; is NOT a valid statement Select "TableName.FieldName" from [TableName]; is a valid statement but returns the litteral string 'TableName.FieldName' as a result.

Published property RecursiveTriggers: Boolean Read GetFRecursiveTriggers Write SetFRecursiveTriggers;

This property gets or sets the database Recursive Triggers pragma as described in the Sqlite help

Published property SecureDelete: Boolean Read GetFSecureDelete Write SetFSecureDelete;

This property gets or sets the database Secure Delete pragma as described in the Sqlite help

Published property Synchronous: TSqlitePassSynchronous Read GetFSynchronous Write SetFSynchronous;

This property gets or sets the database Synchronous pragma as described in the Sqlite help

Published property TemporaryStorage: TSqlitePassTempStore Read GetFTemporaryStorage Write SetFTemporaryStorage;

This property gets or sets the database TemporaryStorage pragma as described in the Sqlite help

Published property TemporaryStorageDir: String Read GetFTemporaryStorageDir Write SetFTemporaryStorageDir;

This property gets or sets the database TemporaryStorage pragma as described in the Sqlite help


Generated by PasDoc 0.11.0 on 2010-09-10 15:54:38