Class TSqlitePassSelectStmtTableDef

DescriptionHierarchyFieldsMethodsProperties

Unit

Declaration

type TSqlitePassSelectStmtTableDef = class(TSqlitePassGenericTableDef)

Description

TSqlitePassSelectStmtTableDef : When a SQL select statement is executed, a TSqlitePassSelectStmtTableDef is generated for each table used in the SQL statement. Each TSqlitePassSelectStmtTableDef stores information on one table in order to know how to insert, update or delete records.

for an insert statement, we need to know the : name of the table (from TSqlitePassGenericTableDef.TableName or FullTableName properties) fields names (from the fieldDefs property) fields values to be inserted (from the recordset) fields Datatype (from the fieldDefs property) fields BufferSize (from the fieldDefs property)

for an update statement, we need to know the : if the record was modified (at least one field was modified) from the recordset name of the table rowid number of the record (from the recordset) fields values to be inserted (from the recordset and translate it to ) fields index fields Datatype fields BufferSize

for a delete statement, we need to know the name of the table rowid number of the record

Hierarchy

Overview

Methods

Public Constructor Create(Owner: TSqlitePassSelectStmtTableDefs);
Public Destructor Destroy; override;
Public procedure Assign(Source: TSqlitePassTableDef);
Public procedure PostDelete(Const RowId: Int64; Const RecordBuffer: PRecBuffer);
Public procedure PostInsert(Const RecordBuffer: PRecBuffer);
Public procedure PostUpdate(Const RowId: Int64; Const RecordBuffer: PRecBuffer);
Public procedure PrepareInsertDeleteSQLStmts;
Public procedure UnprepareSQLStmts;

Properties

Public property AvailableOperations: TSqlitePassAvailableOperations Read FAvailableOperations;
Public property FieldDefs: TSqlitePassSelectStmtFieldDefs Read FFieldDefs;

Description

Methods

Public Constructor Create(Owner: TSqlitePassSelectStmtTableDefs);
 
Public Destructor Destroy; override;
 
Public procedure Assign(Source: TSqlitePassTableDef);
 
Public procedure PostDelete(Const RowId: Int64; Const RecordBuffer: PRecBuffer);
 
Public procedure PostInsert(Const RecordBuffer: PRecBuffer);
 
Public procedure PostUpdate(Const RowId: Int64; Const RecordBuffer: PRecBuffer);
 
Public procedure PrepareInsertDeleteSQLStmts;
 
Public procedure UnprepareSQLStmts;
 

Properties

Public property AvailableOperations: TSqlitePassAvailableOperations Read FAvailableOperations;
 
Public property FieldDefs: TSqlitePassSelectStmtFieldDefs Read FFieldDefs;
 

Generated by PasDoc 0.11.0 on 2010-03-22 23:38:11