Description | Hierarchy | Fields | Methods | Properties |
type TSqlitePassDataset = class(TDataSet)
The TSqlitePassDataset
is a link between your application and the database content. TSqlitePassDataset
enables you to access tables, queries or even to create direct SQL queries to read and write data from/to your database.
![]() |
Constructor Create(AOwner: TComponent); override; |
![]() |
Destructor Destroy; override; |
![]() |
Function BookmarkValid(Bookmark: TBookmark): Boolean; override; |
![]() |
Function CompareBookmarks(Bookmark1, Bookmark2: TBookmark): Integer; override; |
![]() |
Function CreateBlobStream(Field: TField; Mode: TBlobStreamMode): TStream; override; |
![]() |
Function GetFieldData(Field: TField; Buffer: Pointer): Boolean; override; |
![]() |
function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; override; |
![]() |
function LocateFirst: Boolean; |
![]() |
function LocateLast: Boolean; |
![]() |
function LocateNext: Boolean; |
![]() |
function LocatePrior: Boolean; |
![]() |
function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant; override; |
![]() |
function LookupFirst: Variant; |
![]() |
function LookUpLast: Variant; |
![]() |
function LookupNext: Variant; |
![]() |
function LookupPrior: Variant; |
![]() |
Procedure ApplyChanges; |
![]() |
Procedure ApplyFilter; |
![]() |
Procedure CancelChanges; |
![]() |
procedure CloseBlob(Field: TField); override; |
![]() |
Procedure EmptyTable; |
![]() |
Procedure Sort; |
![]() |
property Active; |
![]() |
property AfterCancel; |
![]() |
property AfterClose; |
![]() |
property AfterDelete; |
![]() |
property AfterEdit; |
![]() |
property AfterInsert; |
![]() |
property AfterOpen; |
![]() |
property AfterPost; |
![]() |
property AfterScroll; |
![]() |
property AutoCalcFields; |
![]() |
property BeforeCancel; |
![]() |
property BeforeClose; |
![]() |
property BeforeDelete; |
![]() |
property BeforeEdit; |
![]() |
property BeforeInsert; |
![]() |
property BeforeOpen; |
![]() |
property BeforePost; |
![]() |
property BeforeScroll; |
![]() |
property Database: TSqlitePassDatabase Read GetFDatabase Write SetFDatabase; |
![]() |
property DatabaseAutoActivate: Boolean Read FDatabaseAutoActivate Write FDatabaseAutoActivate; |
![]() |
property DatasetName: String Read FDatasetName Write SetFDatasetName; |
![]() |
property DatasetType: TSqlitePassDatasetType Read FDatasetType; |
![]() |
property ExportMethod: TSqlitePassDatasetExportMethod Read FExportMethod Write FExportMethod; |
![]() |
property Filter; |
![]() |
property Filtered; |
![]() |
property FilterOptions; |
![]() |
property FilterRecordLowerLimit: Cardinal Read FFilterRecordLowerLimit Write SetFFilterRecordLowerLimit; |
![]() |
property FilterRecordUpperLimit: Cardinal Read FFilterRecordUpperLimit Write setFFilterRecordUpperLimit; |
![]() |
property IndexDefs: TSqlitePassDatasetIndexDefs Read FIndexDefs Write FIndexDefs; |
![]() |
property LocateMoveState: TGetResult read FLocateMoveState; |
![]() |
property LocateRecordCount: Integer Read GetLocateRecordCount; |
![]() |
property LocateSmartRefresh: Boolean Read FLocateSmartRefresh Write FLocateSmartRefresh; |
![]() |
property LookUpCache: Boolean Read FLookUpCache Write SetFLookUpCache; |
![]() |
property LookUpMaxRecordCount: Integer Read FLookUpMaxRecordCount Write FLookUpMaxRecordCount; |
![]() |
property LookUpOptions: TLocateOptions Read FLookUpOptions Write FLookUpOptions; |
![]() |
property LookUpSmartRefresh: Boolean Read FLookUpSmartRefresh Write FLookUpSmartRefresh; |
![]() |
property MasterFields: string read GetMasterFields write SetMasterFields; |
![]() |
property MasterSource: TDataSource read GetMasterDataSource write SetMasterDataSource; |
![]() |
property MasterSourceAutoActivate: Boolean read FMasterAutoActivate write FMasterAutoActivate; |
![]() |
property OnCalcFields; |
![]() |
property OnDeleteError; |
![]() |
property OnEditError; |
![]() |
property OnExportProgress: TSqlitePassDatasetExportProgressEvent Read FOnExportProgress Write FOnExportProgress; |
![]() |
property OnFilterRecord : TSqlitePassDatasetFilterRecordEvent read FOnFilterRecord write FOnFilterRecord; |
![]() |
property OnImportProgress: TSqlitePassDatasetImportProgressEvent Read FOnImportProgress Write FOnImportProgress; |
![]() |
property OnNewRecord; |
![]() |
property OnPostError; |
![]() |
property ParamCheck: Boolean Read FParamCheck Write FParamCheck; |
![]() |
property ParamCount: Integer read GetParamsCount; |
![]() |
property Params: TParams read FParams Write SetParamsList Stored False; |
![]() |
property ProcessMessages: Boolean Read FProcessMessages Write FProcessMessages; |
![]() |
property ReadOnly: Boolean Read GetFReadOnly Write SetFReadOnly default False; |
![]() |
property RecordsCacheCapacity: TSqlitePassRecordsCacheCapacity Read FRecordsCacheCapacity Write FRecordsCacheCapacity; |
![]() |
property SortCaclFields: Boolean Read FSortCalcFields Write SetFSortCalcFields; |
![]() |
property Sorted: Boolean Read FSorted Write SetFSorted; |
![]() |
property SortedBy: String Read FSortedBy Write SetFSortedBy; |
![]() |
property SortMode: TSqlitePassSortMode Read FSortMode Write SetFSortMode; |
![]() |
property SQL: TStringList Read FSQL Write SetFSQL; |
![]() |
property SQLSelectStmt: TSqlitePassSelectStmt Read FSQLSelectStmt; |
![]() |
property VersionInfo: TSqlitePassDatasetVersionInfo Read FVersionInfo Write FVersionInfo; |
![]() |
property WriteMode: TSqlitePassWriteMode Read FWriteMode Write SetFWriteMode; |
![]() |
Constructor Create(AOwner: TComponent); override; |
—– Constructor - Destructor —– |
![]() |
Destructor Destroy; override; |
![]() |
Function BookmarkValid(Bookmark: TBookmark): Boolean; override; |
—– Bookmarks —– |
![]() |
Function CompareBookmarks(Bookmark1, Bookmark2: TBookmark): Integer; override; |
![]() |
Function CreateBlobStream(Field: TField; Mode: TBlobStreamMode): TStream; override; |
—– Blobs —– |
![]() |
Function GetFieldData(Field: TField; Buffer: Pointer): Boolean; override; |
—– —– |
![]() |
function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; override; |
—– |
![]() |
function LocateFirst: Boolean; |
![]() |
function LocateLast: Boolean; |
![]() |
function LocateNext: Boolean; |
![]() |
function LocatePrior: Boolean; |
![]() |
function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant; override; |
—– |
![]() |
function LookupFirst: Variant; |
![]() |
function LookUpLast: Variant; |
![]() |
function LookupNext: Variant; |
![]() |
function LookupPrior: Variant; |
![]() |
Procedure ApplyChanges; |
—– Apply or Cancel records modification if WriteMode is wmPostpone —– |
![]() |
Procedure ApplyFilter; |
—– —– |
![]() |
Procedure CancelChanges; |
![]() |
procedure CloseBlob(Field: TField); override; |
![]() |
Procedure EmptyTable; |
![]() |
Procedure Sort; |
![]() |
property AfterCancel; |
![]() |
property AfterClose; |
![]() |
property AfterDelete; |
![]() |
property AfterEdit; |
![]() |
property AfterInsert; |
![]() |
property AfterOpen; |
![]() |
property AfterPost; |
![]() |
property AfterScroll; |
![]() |
property AutoCalcFields; |
— |
![]() |
property BeforeCancel; |
![]() |
property BeforeClose; |
![]() |
property BeforeDelete; |
![]() |
property BeforeEdit; |
![]() |
property BeforeInsert; |
![]() |
property BeforeOpen; |
— |
![]() |
property BeforePost; |
![]() |
property BeforeScroll; |
![]() |
property Database: TSqlitePassDatabase Read GetFDatabase Write SetFDatabase; |
Selects the TsqlitePassDatabase component you want to depend on. |
![]() |
property DatabaseAutoActivate: Boolean Read FDatabaseAutoActivate Write FDatabaseAutoActivate; |
When set to True, opens automatically the database if needed. |
![]() |
property DatasetName: String Read FDatasetName Write SetFDatasetName; |
Once you are connected to a database, enters a table name or a query name. At design time, a dialog will let you choose your dataset among all the available database datasets. |
![]() |
property DatasetType: TSqlitePassDatasetType Read FDatasetType; |
This property is only read. It gives you information about the currently selected dataset and can be one of the following values : dtUnkown : The dataset type could not be recognized or the DatasetName property is empty. dtTable : The dataset is a table. dtQuery : The dataset is a query. dtView : The dataset is a view. dtSqlDirect : The SQL property has been modified or you entered a new SQL query. When the SQL text is changed, the DatasetName will automatically be set to '' assuming that the DatasetName and SQL text don't match anymore. |
![]() |
property ExportMethod: TSqlitePassDatasetExportMethod Read FExportMethod Write FExportMethod; |
![]() |
property Filter; |
Classic dataset Example1 : country = 'France' Example1 : customer like '%cur%' |
![]() |
property Filtered; |
Determines whether or not the different filters are activated. The TsqlitePassDataset component can handle three filter levels that will be applied in this priority order : 1 : MasterFields/DetailFields property 2 : Filter property 3 : RecordLowerLimit/RecordUpperLimit properties |
![]() |
property FilterOptions; |
![]() |
property FilterRecordLowerLimit: Cardinal Read FFilterRecordLowerLimit Write SetFFilterRecordLowerLimit; |
|
![]() |
property FilterRecordUpperLimit: Cardinal Read FFilterRecordUpperLimit Write setFFilterRecordUpperLimit; |
If greater than 1, the -nth first records will be retrieved. In other words, if FilterUpperLimit = 4 and FilterLowerLimit = 0 then only the four first records will be retrieved from the query. If lesser than 0, the -nth last records will be retrieved. In other words, if FilterUpperLimit = -9 and FilterLowerLimit = 0 then only the nine last records will be retrieved from the query. |
![]() |
property IndexDefs: TSqlitePassDatasetIndexDefs Read FIndexDefs Write FIndexDefs; |
The |
![]() |
property LocateMoveState: TGetResult read FLocateMoveState; |
![]() |
property LocateRecordCount: Integer Read GetLocateRecordCount; |
![]() |
property LocateSmartRefresh: Boolean Read FLocateSmartRefresh Write FLocateSmartRefresh; |
![]() |
property LookUpCache: Boolean Read FLookUpCache Write SetFLookUpCache; |
![]() |
property LookUpMaxRecordCount: Integer Read FLookUpMaxRecordCount Write FLookUpMaxRecordCount; |
![]() |
property LookUpOptions: TLocateOptions Read FLookUpOptions Write FLookUpOptions; |
![]() |
property LookUpSmartRefresh: Boolean Read FLookUpSmartRefresh Write FLookUpSmartRefresh; |
![]() |
property MasterFields: string read GetMasterFields write SetMasterFields; |
Classic table At design time, a dialog will let you create or modify the relation between A relation is defined like this : MasterFieldName=DetailFieldName If you want set several relations, they must be separated by a ';' MasterFieldName1=DetailFieldName1;MasterFieldName2=DetailFieldName2 |
![]() |
property MasterSource: TDataSource read GetMasterDataSource write SetMasterDataSource; |
Classic table |
![]() |
property MasterSourceAutoActivate: Boolean read FMasterAutoActivate write FMasterAutoActivate; |
![]() |
property OnCalcFields; |
![]() |
property OnDeleteError; |
![]() |
property OnEditError; |
![]() |
property OnExportProgress: TSqlitePassDatasetExportProgressEvent Read FOnExportProgress Write FOnExportProgress; |
Additionnal Events |
![]() |
property OnFilterRecord : TSqlitePassDatasetFilterRecordEvent read FOnFilterRecord write FOnFilterRecord; |
![]() |
property OnImportProgress: TSqlitePassDatasetImportProgressEvent Read FOnImportProgress Write FOnImportProgress; |
![]() |
property OnNewRecord; |
![]() |
property OnPostError; |
![]() |
property ParamCheck: Boolean Read FParamCheck Write FParamCheck; |
![]() |
property ParamCount: Integer read GetParamsCount; |
—– Properties —– |
![]() |
property Params: TParams read FParams Write SetParamsList Stored False; |
![]() |
property ProcessMessages: Boolean Read FProcessMessages Write FProcessMessages; |
![]() |
property ReadOnly: Boolean Read GetFReadOnly Write SetFReadOnly default False; |
![]() |
property RecordsCacheCapacity: TSqlitePassRecordsCacheCapacity Read FRecordsCacheCapacity Write FRecordsCacheCapacity; |
![]() |
property SortCaclFields: Boolean Read FSortCalcFields Write SetFSortCalcFields; |
![]() |
property Sorted: Boolean Read FSorted Write SetFSorted; |
Determines whether or not the sortedBy property is activated. |
![]() |
property SortedBy: String Read FSortedBy Write SetFSortedBy; |
The Example : 'car_names ASC, car_types DESC'. |
![]() |
property SortMode: TSqlitePassSortMode Read FSortMode Write SetFSortMode; |
![]() |
property SQL: TStringList Read FSQL Write SetFSQL; |
For tables, it will automatically be set to :
For queries, it will reflect the query |
![]() |
property SQLSelectStmt: TSqlitePassSelectStmt Read FSQLSelectStmt; |
![]() |
property VersionInfo: TSqlitePassDatasetVersionInfo Read FVersionInfo Write FVersionInfo; |
![]() |
property WriteMode: TSqlitePassWriteMode Read FWriteMode Write SetFWriteMode; |