Unit SqlitePassDbo

DescriptionusesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

Description

The unit SqlitePassDbo defines all the interface definitions for the SqlitePass Database Objects Project. The implementations are located in SqlitePassEngine.inc, SqlitePassDatabase.inc, SqlitePassDatabaseParts.inc, SqlitePassDataset.inc, SqlitePassSqlStmts.inc and SqlitePassRecordset.inc files.

—————————————————————————

This library is free software; you can redistribute it and/or modify it under the terms of the GNU Library General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details.

You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

—————————————————————————

Major changes are indicated in the \Documentation\Changes.pdf file

—————————————————————————

uses

Overview

Classes, Interfaces, Objects and Records

Name Description
record TMidRecordBuffer  
Class TSqlitePassBlobStream —– Blob fields stream —–
Class TSqlitePassCustomFieldDef TSqlitePassCustomFieldDef is used by TSqlitePassDatabaseDataTypeOptions when you need to define your own fieldtype translations
Class TSqlitePassCustomFieldDefs TSqlitePassCustomFieldDefs
Class TSqlitePassDatabase The TSqlitePassDatabase component is the main link between your application and the sqlite library.
Class TSqlitePassDatabaseAttached TSqliteAttachedDatabases : Maintain a list of all attached databases
Class TSqlitePassDatabaseDataTypeOptions The TSqlitePassDatabaseDataTypeOptions is used by the TSqlitePassDatabase.DatatypeOptions property and gives you the opportunity to set custom or default behaviors for a given database.
Class TSqlitePassDatabaseError  
Class TSqlitePassDatabaseErrorItem  
Class TSqlitePassDatabaseIndex  
Class TSqlitePassDatabaseIndexDefs  
Class TSqlitePassDatabaseOptions TSqlitePassDatabaseOptions
Class TSqlitePassDatabasesAttached  
Class TSqlitePassDatabaseVersionInfo TVersionInfo
record TSqlitePassDataReader TSqlitePassFieldAccessor
Class TSqlitePassDataset The TSqlitePassDataset is a link between your application and the database content.
Class TSqlitePassDatasetIndex  
Class TSqlitePassDatasetIndexDefs  
Class TSqlitePassDatasets TSqlitePassDatasets : Maintain a list of all datasets connected to the database
Class TSqlitePassDatasetVersionInfo  
Class TSqlitePassEngine  
Class TSqlitePassFieldFilter  
Class TSqlitePassFieldFilterExp  
Class TSqlitePassFieldFilters A list of defined Filters matching Fields List
Class TSqlitePassFieldTypesDefaultTranslationRules TSqlitePassFieldTypesDefaultTranslationRules
Class TSqlitePassFieldTypesGenericTranslationRules TSqlitePassFieldTypesGenericTranslationRules
Class TSqlitePassFieldTypesTranslationRules TSqlitePassFieldTypesTranslationRules
Class TSqlitePassFieldTypeTranslationRule TSqlitePassFieldTypeTranslationRule.
Class TSqlitePassGenericFieldDef TSqlitePassGenericFieldDef is a generic class used to store information on fields presents in the database tables.
Class TSqlitePassGenericTableDef TableDefs
Class TSqlitePassIndex  
Class TSqlitePassIndexColumn  
Class TSqlitePassIndexColumns  
Class TSqlitePassInMemoryIndex  
Class TSqlitePassInMemoryIndexes  
record TSqlitePassInMemoryIndexInfo  
Class TSqlitePassParam Param
Class TSqlitePassParams Params
Class TSqlitePassQueryDef QueryDefs
Class TSqlitePassQueryDefs  
Class TSqlitePassRecordset Internal cache holding the records returned by a table/query It is designed to provide data to TSqlitePassDataset
Class TSqlitePassSelectStmt  
Class TSqlitePassSelectStmtFieldDef TSqlitePassBufferToSqliteValue = procedure (Const Recordset: TSqlitePassRecordset; Const RecordBuffer: PRecBuffer; Const RecordFieldIndex: Integer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer);
Class TSqlitePassSelectStmtFieldDefs TSqlitePassSelectStmtFieldDefs is a collection of TSqlitePassSelectStmtFieldDef
Class TSqlitePassSelectStmtTableDef TSqlitePassSelectStmtTableDef : When a SQL select statement is executed, a TSqlitePassSelectStmtTableDef is generated for each table used in the SQL statement.
Class TSqlitePassSelectStmtTableDefs TSqlitePassSelectStmtTableDefs : represents a collection of TSqlitePassSelectStmtTableDef.
Class TSqlitePassSQLSections The TSqlitePassSQLSections is an utility object used to : Split a SQL statement into a list of String for each SQL Keyword
Class TSqlitePassSQLStmt  
Class TSqlitePassSQLStmtDef  
Class TSqlitePassSQLStmtDefs SQL statements collection
Class TSqlitePassSQLToken  
Class TSqlitePassSQLTokenizer The TSqlitePassTokenizer is an utility object used to : Split a SQL statement or a piece of SQL statement into a list of tokens (TSqlitePassSQLToken)

Move to the First, Prior, Next, Last Token Lookup a specific token by text or type Replace a specific token Located before an existing token Remove a specific token Located after an existing token Insert a new token before an existing token Insert a new token after an existing token Set the String to be tokenized and rebuild a String representation from the tokens (Text property)...

Class TSqlitePassSQLTokens  
Class TSqlitePassTableDef  
Class TSqlitePassTableDefs  
Class TSqlitePassTableFieldDef TSqlitePassTableFieldDef is mainly used to get information on fields presents in the database tables and to build a static schema of the database
Class TSqlitePassTableFieldDefs TSqlitePassTableFieldDefs is a collection of TSqlitePassTableFieldDef
Class TSqlitePassTransaction  
Class TSqlitePassTranslator  
Class TSqlitePassTranslator_Kexi Specific translator for Kexi databases
Class TSqlitePassTranslator_SqliteAdmin Empty declaration : nothing to override
Class TSqlitePassTranslator_SqliteExpert Empty declaration : nothing to override
Class TSqlitePassTrigger Triggers
Class TSqlitePassTriggers  
Class TSqlitePassView Views
Class TSqlitePassViews TSqlitePassViews

Functions and Procedures

function AcceptAnsiStringCsValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringCsValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptAnsiStringValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptCurrencyValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptCurrencyValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptCurrencyValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptCurrencyValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptCurrencyValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptCurrencyValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptDoubleValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptDoubleValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptDoubleValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptDoubleValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptDoubleValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptDoubleValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptDummyValue(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptInt64ValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptInt64ValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptInt64ValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptInt64ValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptInt64ValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptInt64ValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptIntegerValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptIntegerValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptIntegerValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptIntegerValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptIntegerValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptIntegerValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoCsValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptMemoValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptValueCmpNotNull(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptValueCmpNull(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringCsValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWideStringValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWordBoolValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
function AcceptWordBoolValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
procedure BindAnsiStringFieldValueBufferToSqliteValueAsUTF8 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindBlobFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindCurrencyFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindDateFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindDateTimeFieldValueBufferToSqliteValueAsJulianDateTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindDateTimeFieldValueBufferToSqliteValueAsMacDateTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindDateTimeFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindDateTimeFieldValueBufferToSqliteValueAsUnixDateTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindDoubleFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindDummyFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindInt64FieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindIntegerFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindTimeFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindUTF8AnsiStringFieldValueBufferToSqliteValueAsUTF16 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindUTF8AnsiStringFieldValueBufferToSqliteValueAsUTF8 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindWideStringFieldValueBufferToSqliteValueAsUTF16 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindWordBoolFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
procedure BindWordBoolFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
function CompareAnsiStringValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareAnsiStringValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareCurrencyValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareCurrencyValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareDoubleValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareDoubleValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareDummyValue(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareInt64ValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareInt64ValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareIntegerValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareIntegerValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareMemoValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareMemoValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareRecord(Recordset: TSqlitePassRecordset; var MidRecordBuffers: TMidRecordBuffers; var SortedFields: TSqlitePassInMemoryIndexInfos; RecordBuffer: PRecBuffer): Integer; inline;
function CompareWideStringValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareWideStringValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareWordBoolValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function CompareWordBoolValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
function GetMemoValue(Const Recordset: TSqlitePassRecordset; Const FieldValue: Pointer): AnsiString; inline;
procedure InsertionSort(Recordset: TSqlitePassRecordset; RecordBufferList: PRecBufferList; var MidRecordBuffers: TMidRecordBuffers; var SortedFields: TSqlitePassInMemoryIndexInfos;Const Lo, Hi: Integer); inline;
procedure SqliteValueDateTimeTextToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueJulianDateTimeToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueMacDateTimeToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueTextToDate (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueTextToTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueTextToWordBool (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToAnsiString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToBlob (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToCurrency (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToDummy (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToInt64 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToInteger (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToRawString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToRawWideString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToUTF16WideString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToUTF8AnsiString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueToWordBool (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
procedure SqliteValueUnixDateTimeToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;

Types

PSqlitePassExecCallBack = ˆTSqlitePassExecCallBack;
PSqlitePassRecordState = ˆTSqlitePassRecordState;
StmtType = (...);
TConnectEvent = procedure(Database: TSqlitePassDatabase) of object;
TDataTypeConversion = procedure (Database: TSqlitePassDatabase; TableDef: TSqlitePassTableDef; FiedDef: TSqlitePassTableFieldDef) of object;
TFieldFilterExpAcceptValueFunc = function(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean;
TMidRecordBuffers = Array of TMidRecordBuffer;
TSqlitePassApplyMode = (...);
TSqlitePassApplyModes = set of TSqlitePassApplyMode;
TSqlitePassAutoVacuumType = (...);
TSqlitePassAvailableOperations = set of (aoRead, aoBind, aoInsert, aoUpdate, aoDelete);
TSqlitePassBooleanStorage = (...);
TSqlitePassCompareColumnValue = function(Const Recordset: TSqlitePassRecordset; Const FieldBufferValue1, FieldBufferValue2: Pointer): Integer;
TSqlitePassDatabaseObjectTypes = (...);
TSqlitePassDatabaseState = set of (dbsInternalOpen, dbsRefreshingDefinitions);
TSqlitePassDatabaseType = (...);
TSqlitePassDatasetExportProgressEvent = procedure(Current, Total:Integer) of object;
TSqlitePassDatasetFilterRecordEvent = procedure(DataSet: TDataSet; var Accept: Boolean) of object;
TSqlitePassDatasetImportProgressEvent = procedure(Current:Integer) of object;
TSqlitePassDatasetType = (...);
TSqlitePassDataTypeDetectionMode = (...);
TSqlitePassDataTypeMappingMode = (...);
TSqlitePassDataTypeStorageLoadOptions = set of (loDefaultProperties, loCustomProperties, loTranslationRules, loCustomFieldDefs);
TSqlitePassDataTypeStorageSaveOptions = set of (soCustomProperties, soTranslationRules, soCustomFieldDefs);
TSqlitePassDateStorage = TSqlitePassBooleanStorage;
TSqlitePassDateTimeStorage = (...);
TSqlitePassEncoding = (...);
TSqlitePassExecCallBack = function(acolumns: Integer; aColumnValues, aColumnNames:ppAnsiChar):integer of object;
TSqlitePassFilterChanges = set of (fcSQLFilter, fcDirectFilters, fcLowerLimit, fcUpperLimit);
TSqlitePassFilterComparisonOperators = (...);
TSqlitePassFilterLogicalOperators = (...);
TSqlitePassFilterMode = (...);
TSqlitePassGetPragmaCallback = function(UserData: Pointer; ColumnCount: Integer; ColumnValues, ColumnNames: PPointer): Integer; cdecl;
TSqlitePassIndexDirection = (...);
TSqlitePassInMemoryIndexInfos = Array of TSqlitePassInMemoryIndexInfo;
TSqlitePassJournalMode = (...);
TSqlitePassLockingMode = (...);
TSqlitePassPageSize = 512..32768;
TSqlitePassPostType = (...);
TSqlitePassQuoteStyle = (...);
TSqlitePassRecordsCacheCapacity = 1..MaxInt;
TSqlitePassRecordState = Byte;
TSqlitePassRecordStateType = 0..7;
TSqlitePassRecordStateValue = 0..1;
TSqlitePassSortMode = (...);
TSqlitePassSQLChange = (...);
TSqlitePassSQLChanges = set of TSqlitePassSQLChange;
TSqlitePassSqliteValueToValueBuffer = procedure(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer);
TSqlitePassSQLTokenizerCleanOptions = set of TSqlitePassSQLTokenType;
TSqlitePassSQLTokenizerOptions = set of (toClean, toUpperCase);
TSqlitePassSQLTokenType = (...);
TSqlitePassSynchronous = (...);
TSqlitePassSystemEncoding = (...);
TSqlitePassTempStore = (...);
TSqlitePassTimeStorage = TSqlitePassDateStorage;
TSqlitePassUnicodeEncoding = (...);
TSqlitePassValueBufferToSqliteValue = procedure(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer);
TSqlitePassVerboseLevel = vlSilent..vlLogAndShow;
TSqlitePassWriteMode = (...);

Description

Functions and Procedures

function AcceptAnsiStringCsValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringCsValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringCsValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;

Case Sensitive

function AcceptAnsiStringCsValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringCsValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringCsValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringCsValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringCsValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringCsValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;

Not Case Sensitive

function AcceptAnsiStringValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptAnsiStringValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptCurrencyValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptCurrencyValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptCurrencyValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptCurrencyValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptCurrencyValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptCurrencyValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptDoubleValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptDoubleValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptDoubleValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptDoubleValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptDoubleValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptDoubleValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptDummyValue(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;

Filter functions

function AcceptInt64ValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptInt64ValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptInt64ValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptInt64ValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptInt64ValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptInt64ValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptIntegerValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptIntegerValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptIntegerValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptIntegerValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptIntegerValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptIntegerValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;

Case Sensitive

function AcceptMemoCsValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoCsValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;

Not Case Sensitive

function AcceptMemoValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptMemoValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptValueCmpNotNull(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptValueCmpNull(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;

Case Sensitive

function AcceptWideStringCsValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringCsValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpAnywhere(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpEndWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;

Not Case Sensitive

function AcceptWideStringValueCmpGreater(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpGreaterOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpLesser(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpLesserOrEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWideStringValueCmpStartWith(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWordBoolValueCmpEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
function AcceptWordBoolValueCmpNotEqual(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean; inline;
 
procedure BindAnsiStringFieldValueBufferToSqliteValueAsUTF8 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindBlobFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindCurrencyFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindDateFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindDateTimeFieldValueBufferToSqliteValueAsJulianDateTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindDateTimeFieldValueBufferToSqliteValueAsMacDateTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindDateTimeFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindDateTimeFieldValueBufferToSqliteValueAsUnixDateTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindDoubleFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindDummyFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;

Translates a value from internal field or param value buffer to a sqlite value. Then binds this value to parameter in SELECT - INSERT - UPDATE - DELETE SQL statement StmtFieldNo is 1 based, FieldIndex is Zero based

procedure BindInt64FieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindIntegerFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindTimeFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindUTF8AnsiStringFieldValueBufferToSqliteValueAsUTF16 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindUTF8AnsiStringFieldValueBufferToSqliteValueAsUTF8 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindWideStringFieldValueBufferToSqliteValueAsUTF16 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindWordBoolFieldValueBufferToSqliteValue (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
procedure BindWordBoolFieldValueBufferToSqliteValueAsText (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer); inline;
 
function CompareAnsiStringValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareAnsiStringValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareCurrencyValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareCurrencyValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareDoubleValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareDoubleValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareDummyValue(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;

Sort Comparison functions

function CompareInt64ValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareInt64ValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareIntegerValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareIntegerValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareMemoValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareMemoValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareRecord(Recordset: TSqlitePassRecordset; var MidRecordBuffers: TMidRecordBuffers; var SortedFields: TSqlitePassInMemoryIndexInfos; RecordBuffer: PRecBuffer): Integer; inline;
 
function CompareWideStringValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareWideStringValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;
 
function CompareWordBoolValueAsc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;

Sort Comparison functions - Asc We could call the above *Desc functions and multiplicate the result by -1, but the code is faster this way

function CompareWordBoolValueDesc(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer1, FieldValueBuffer2: Pointer): Integer; inline;

Sort Comparison functions - Desc

function GetMemoValue(Const Recordset: TSqlitePassRecordset; Const FieldValue: Pointer): AnsiString; inline;

Memo

procedure InsertionSort(Recordset: TSqlitePassRecordset; RecordBufferList: PRecBufferList; var MidRecordBuffers: TMidRecordBuffers; var SortedFields: TSqlitePassInMemoryIndexInfos;Const Lo, Hi: Integer); inline;
 
procedure SqliteValueDateTimeTextToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueJulianDateTimeToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueMacDateTimeToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueTextToDate (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueTextToTime (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueTextToWordBool (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToAnsiString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToBlob (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToCurrency (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToDummy (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;

Data Reader - Translate functions

procedure SqliteValueToInt64 (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToInteger (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToRawString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToRawWideString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToUTF16WideString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToUTF8AnsiString (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueToWordBool (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 
procedure SqliteValueUnixDateTimeToDouble (Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer); inline;
 

Types

PSqlitePassExecCallBack = ˆTSqlitePassExecCallBack;
 
PSqlitePassRecordState = ˆTSqlitePassRecordState;
 
StmtType = (...);
 
Values
  • stCreate:  
  • stCreateTable:  
  • stSelect:  
  • stInsert:  
  • stUpdate:  
  • stDelete:  
  • stUnknown:  
TConnectEvent = procedure(Database: TSqlitePassDatabase) of object;

TSqlitePassDatabase Events

TDataTypeConversion = procedure (Database: TSqlitePassDatabase; TableDef: TSqlitePassTableDef; FiedDef: TSqlitePassTableFieldDef) of object;
 
TFieldFilterExpAcceptValueFunc = function(Const Recordset: TSqlitePassRecordset; Const FieldValue, FilterValue: Pointer):Boolean;
 
TMidRecordBuffers = Array of TMidRecordBuffer;
 
TSqlitePassApplyMode = (...);
 
Values
  • amOverwriteDatabaseFileSettings:  
  • amAutoVacuum:  
  • amCacheSize:  
  • amCaseSensitiveLike:  
  • amCountChanges:  
  • amDefaultCacheSize:  
  • amFullColumnNames:  
  • amForeignKeys:  
  • amJournalMode:  
  • amJournalSizeLimit:  
  • amLockingMode:  
  • amMaxPageCount:  
  • amPageSize:  
  • amRecursiveTriggers:  
  • amSecureDelete:  
  • amSynchronous:  
  • amTemporaryStorage:  
  • amTemporaryStorageDir:  
TSqlitePassApplyModes = set of TSqlitePassApplyMode;
 
TSqlitePassAutoVacuumType = (...);
 
Values
  • avNone:  
  • avFull:  
  • avIncremental:  
TSqlitePassAvailableOperations = set of (aoRead, aoBind, aoInsert, aoUpdate, aoDelete);
 
TSqlitePassBooleanStorage = (...);

Datatypes detection and conversion

Values
  • asInteger:  
  • asText:  
TSqlitePassCompareColumnValue = function(Const Recordset: TSqlitePassRecordset; Const FieldBufferValue1, FieldBufferValue2: Pointer): Integer;

Internal function to compare buffers value when sorting or indexing fields

TSqlitePassDatabaseObjectTypes = (...);
 
Values
  • dboAll:  
  • dboTableDefs:  
  • dboQueryDefs:  
  • dboIndexDefs:  
  • dboViews:  
  • dboTriggers:  
TSqlitePassDatabaseState = set of (dbsInternalOpen, dbsRefreshingDefinitions);
 
TSqlitePassDatabaseType = (...);
 
Values
  • dbtSqlitePass:  
  • dbtKexi:  
  • dbtSqliteAdmin:  
  • dbtSqlite4Fpc:  
  • dbtSqliteExpert:  
  • dbtUnknown:  
TSqlitePassDatasetExportProgressEvent = procedure(Current, Total:Integer) of object;

Events

TSqlitePassDatasetFilterRecordEvent = procedure(DataSet: TDataSet; var Accept: Boolean) of object;
 
TSqlitePassDatasetImportProgressEvent = procedure(Current:Integer) of object;
 
TSqlitePassDatasetType = (...);
 
Values
  • dtTable:  
  • dtQuery:  
  • dtView:  
  • dtSQLSelect:  
  • dtSQLDirect:  
  • dtUnknown:  
TSqlitePassDataTypeDetectionMode = (...);
 
Values
  • dmTypeName:  
  • dmDbSpecific:  
  • dmCustom:  
  • dmForceStr:  
TSqlitePassDataTypeMappingMode = (...);
 
Values
  • mmExact:  
  • mmExactNoCase:  
  • mmPartial:  
  • mmPartialNoCase:  
  • mmAll:  
TSqlitePassDataTypeStorageLoadOptions = set of (loDefaultProperties, loCustomProperties, loTranslationRules, loCustomFieldDefs);
 
TSqlitePassDataTypeStorageSaveOptions = set of (soCustomProperties, soTranslationRules, soCustomFieldDefs);
 
TSqlitePassDateStorage = TSqlitePassBooleanStorage;
 
TSqlitePassDateTimeStorage = (...);
 
Values
  • dtsDateTime:  
  • dtsJulian:  
  • dtsText:  
  • dtsUnix:  
  • dtsMac:  
TSqlitePassEncoding = (...);
 
Values
  • UTF8:  
  • UTF16:  
  • UTF16le:  
  • UTF16be:  
TSqlitePassExecCallBack = function(acolumns: Integer; aColumnValues, aColumnNames:ppAnsiChar):integer of object;
 
TSqlitePassFilterChanges = set of (fcSQLFilter, fcDirectFilters, fcLowerLimit, fcUpperLimit);

Filtering

TSqlitePassFilterComparisonOperators = (...);
 
Values
  • CmpUnknown:  
  • CmpEqual:  
  • CmpNotEqual:  
  • CmpGreater:  
  • CmpGreateOrEqual:  
  • CmpLesserOrEqual:  
  • CmpLesser:  
  • CmpNull:  
  • CmpNotNull:  
TSqlitePassFilterLogicalOperators = (...);
 
Values
  • opNone:  
  • opAnd:  
  • opOr:  
TSqlitePassFilterMode = (...);
 
Values
  • fmDirect:  
  • fmSQL:  
  • fmSQLDirect:  
TSqlitePassGetPragmaCallback = function(UserData: Pointer; ColumnCount: Integer; ColumnValues, ColumnNames: PPointer): Integer; cdecl;
 
TSqlitePassIndexDirection = (...);

Database indexes management (managed by sqlite engine)

Values
  • cidAscending:  
  • cidDescending:  
  • cidUnknown:  
TSqlitePassInMemoryIndexInfos = Array of TSqlitePassInMemoryIndexInfo;
 
TSqlitePassJournalMode = (...);
 
Values
  • jmDelete:  
  • jmTruncate:  
  • jmPersist:  
  • jmMemory:  
  • jmOff:  
TSqlitePassLockingMode = (...);
 
Values
  • lmNormal:  
  • lmExclusive:  
TSqlitePassPageSize = 512..32768;
 
TSqlitePassPostType = (...);
 
Values
  • ptInsert:  
  • ptUpdate:  
  • ptDelete:  
TSqlitePassQuoteStyle = (...);
 
Values
  • qsDoubleQuote:  
  • qsBracket:  
  • qsGraveQuote:  
  • qsNone:  
TSqlitePassRecordsCacheCapacity = 1..MaxInt;
 
TSqlitePassRecordState = Byte;
 
TSqlitePassRecordStateType = 0..7;

Record State

TSqlitePassRecordStateValue = 0..1;
 
TSqlitePassSortMode = (...);

Sorting

Values
  • smDirect:  
  • smSQL:  
TSqlitePassSQLChange = (...);
 
Values
  • scSelect:  
  • scWhere:  
  • scGroupBy:  
  • scHaving:  
  • scOrderBy:  
  • scLimit:  
  • scProcess: SQL parts were modified
  • scRefresh: Statement Text needs to be processed
TSqlitePassSQLChanges = set of TSqlitePassSQLChange;

Records need to be refetched from db

TSqlitePassSqliteValueToValueBuffer = procedure(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const ColumnIndex: Integer);

Procedure to bind a sqlite statement value to a FieldValue Buffer value

TSqlitePassSQLTokenizerCleanOptions = set of TSqlitePassSQLTokenType;
 
TSqlitePassSQLTokenizerOptions = set of (toClean, toUpperCase);
 
TSqlitePassSQLTokenType = (...);

Note : Check SqlitePassConst.SqlitePassSQLTokenTypeAsString if TSqlitePassSQLTokenType is modified

Values
  • ttKeyword:  
  • ttIdentifier:  
  • ttDatabaseIdentifier:  
  • ttTableIdentifier:  
  • ttFieldIdentifier:  
  • ttFunctionIdentifier:  
  • ttStar:  
  • ttNumber:  
  • ttDateTime:  
  • ttSingleQuote:  
  • ttDoubleQuote:  
  • ttGraveQuote:  
  • ttHash:  
  • ttPercent:  
  • ttBraceOpen:  
  • ttBraceClose:  
  • ttSquareOpen:  
  • ttSquareClose:  
  • ttRoundOpen:  
  • ttRoundClose:  
  • ttWhitespace:  
  • ttComment:  
  • ttComma:  
  • ttColon:  
  • ttSemiColon:  
  • ttEqual:  
  • ttNotEqual:  
  • ttGreater:  
  • ttGreaterOrEqual:  
  • ttLesser:  
  • ttLesserOrEqual:  
  • ttNull:  
  • ttNotNull:  
  • ttPlus:  
  • ttMinus:  
  • ttAnd:  
  • ttOr:  
  • ttDot:  
  • ttSlash:  
  • ttSeparator:  
  • ttLF:  
  • ttCR:  
  • ttEOF:  
  • ttUnknown:  
TSqlitePassSynchronous = (...);
 
Values
  • syncOff:  
  • syncNormal:  
  • syncFull:  
TSqlitePassSystemEncoding = (...);
 
Values
  • sysANSI:  
  • sysUTF8:  
  • sysUTF16:  
TSqlitePassTempStore = (...);
 
Values
  • tsDefault:  
  • tsFile:  
  • tsMemory:  
TSqlitePassTimeStorage = TSqlitePassDateStorage;
 
TSqlitePassUnicodeEncoding = (...);
 
Values
  • ueAuto:  
  • ueUTF8:  
  • ueUTF16:  
  • ueRawText:  
TSqlitePassValueBufferToSqliteValue = procedure(Const Recordset: TSqlitePassRecordset; Const FieldValueBuffer: PRecBuffer; Const PreparedStmt: Pointer; Const PreparedStmtFieldNo: Integer);

Procedure to bind a FieldValue Buffer to a sqlite statement

TSqlitePassVerboseLevel = vlSilent..vlLogAndShow;
 
TSqlitePassWriteMode = (...);
 
Values
  • wmDirect:  
  • wmPostponed:  

Authors

Created

2006

Last Modified

21.08.2010


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