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, views or even to create direct SQL queries to read and write data from/to your database. It supports almost any kind of fields, including blobs, memo, datetime...etc, and has extended capabilities to quickly sort, filter records (even on calculated or lookup fields). Locate and Lookup is also implemented with some additional methods.
![]() |
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; overload; override; |
![]() |
function Locate(const LocateStmt: String; Options: TLocateOptions): Boolean; reintroduce; overload; |
![]() |
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 LookupEx(const LookupStmt: String; const ResultFields: String; const LookUpResultMaxRecordCount: integer = 0): Variant; overload; |
![]() |
function LookupEx(const KeyFields: String; const KeyValues: Variant; const ResultFields: String; const LookUpResultMaxRecordCount: Integer = 0): Variant; overload; |
![]() |
function LookupFirst(var LookupResult: Variant): Boolean; |
![]() |
function LookUpLast(var LookupResult: Variant): Boolean; |
![]() |
function LookupNext(var LookupResult: Variant): Boolean; |
![]() |
function LookupPrior(var LookupResult: Variant): Boolean; |
![]() |
Function AllocRecordBuffer: PRecBuffer; override; |
![]() |
function FindRecord(Restart, GoForward: Boolean): Boolean; override; |
![]() |
Function GetBookmarkFlag(Buffer: PRecBuffer): TBookmarkFlag; override; |
![]() |
Function GetCanModify: Boolean; override; |
![]() |
function GetFieldClass(FieldType: TFieldType): TFieldClass; override; |
![]() |
Function GetParamsCount: Integer; |
![]() |
Function GetRecNo: Integer; override; |
![]() |
Function GetRecord(Buffer: PRecBuffer; GetMode: TGetMode; DoCheck: Boolean): TGetResult; override; |
![]() |
Function GetRecordCount: Integer; override; |
![]() |
Function GetRecordSize: Word; override; |
![]() |
Function IsCursorOpen: Boolean; override; |
![]() |
Procedure ApplyChanges; |
![]() |
procedure CloseBlob(Field: TField); override; |
![]() |
Procedure EmptyTable; |
![]() |
procedure GetFieldList(List: TList; const FieldNames: string); |
![]() |
Procedure Index; |
![]() |
Procedure Refresh; |
![]() |
procedure RefreshLocate; |
![]() |
Procedure SetFieldData(Field: TField; Buffer: Pointer); override; |
![]() |
Procedure Sort; |
![]() |
procedure AllocateBLOBPointers(Buffer: pAnsiChar); |
![]() |
Procedure ClearCalcFields(Buffer: PRecBuffer); override; |
![]() |
Procedure DefineProperties(Filer: TFiler); override; |
![]() |
procedure DoOnNewRecord; override; |
![]() |
procedure FreeBlobPointers(Buffer: pAnsiChar); |
![]() |
Procedure FreeRecordBuffer(var Buffer: PRecBuffer); override; |
![]() |
procedure FreeRecordPointers(Buffer: pAnsiChar); |
![]() |
Procedure GetBookmarkData(Buffer: pAnsiChar; Data: Pointer); override; |
![]() |
Procedure InternalAddRecord(Buffer: Pointer; Append: Boolean); override; |
![]() |
Procedure InternalCancel; override; |
![]() |
Procedure InternalClearFieldDefs; |
![]() |
Procedure InternalClose; override; |
![]() |
Procedure InternalDelete; override; |
![]() |
Procedure InternalEdit; override; |
![]() |
Procedure InternalFirst; override; |
![]() |
Procedure InternalGotoBookmark(ABookmark: Pointer); override; |
![]() |
Procedure InternalHandleException; override; |
![]() |
Procedure InternalInitFieldDefs; override; |
![]() |
Procedure InternalInitIndexDefs; |
![]() |
Procedure InternalInitRecord(Buffer: PRecBuffer); override; |
![]() |
procedure InternalInsert; override; |
![]() |
Procedure InternalLast; override; |
![]() |
Procedure InternalOpen; override; |
![]() |
Procedure InternalPost; override; |
![]() |
Procedure InternalRefresh; override; |
![]() |
Procedure InternalSetToRecord(Buffer: PRecBuffer); override; |
![]() |
Procedure Loaded; override; |
![]() |
Procedure Notification(AComponent: TComponent; Operation: TOperation); Override; |
![]() |
Procedure ReadParamData(Reader: TReader); |
![]() |
Procedure RefreshActive; |
![]() |
Procedure RefreshFilteredRecords; |
![]() |
Procedure SetBookmarkData(Buffer: pAnsiChar; Data: Pointer); override; |
![]() |
Procedure SetBookmarkFlag(Buffer: PRecBuffer; Value: TBookmarkFlag); override; |
![]() |
procedure SetFiltered(Value: Boolean); override; |
![]() |
procedure SetFilterOptions(Value: TFilterOptions); override; |
![]() |
procedure SetFilterText(Const Value: String); override; |
![]() |
Procedure SetParamsList(Value: TParams); |
![]() |
Procedure SetRecNo(Value: Integer); override; |
![]() |
Procedure UpdateIndexDefs; override; |
![]() |
Procedure UpdateInternalFieldsInfos; |
![]() |
Procedure UpdateParamsList; |
![]() |
Procedure WriteParamData(Writer: TWriter); |
![]() |
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 CalcDisplayedRecordsOnly: Boolean Read FCalcDisplayedRecordsOnly Write SetFCalcDisplayedRecordsOnly; |
![]() |
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 Filter; |
![]() |
property Filtered; |
![]() |
property FilterMode: TSqlitePassFilterMode Read FFilterMode Write FFilterMode; |
![]() |
property FilterOptions; |
![]() |
property FilterRecordLowerLimit: Integer Read FFilterRecordLowerLimit Write SetFFilterRecordLowerLimit; |
![]() |
property FilterRecordUpperLimit: Integer Read FFilterRecordUpperLimit Write setFFilterRecordUpperLimit; |
![]() |
property Filters: TSqlitePassFieldFilters Read FFieldFilters Write FFieldFilters; |
![]() |
property IndexDefs: TSqlitePassDatasetIndexDefs Read FIndexDefs Write FIndexDefs; |
![]() |
property Indexed: Boolean Read FInMemoryIndexed Write SetFInMemoryIndexed; |
![]() |
property IndexedBy: String Read FInMemoryIndexedBy Write SetFInMemoryIndexedBy; |
![]() |
property Indexes: TSqlitePassInMemoryIndexes Read FInMemoryIndexes Write FInMemoryIndexes; |
![]() |
property LocateFilters: TSqlitePassFieldFilters read FLocateFieldFilters write FLocateFieldFilters; |
![]() |
property LocateMoveState: TGetResult read GetLocateMoveState; |
![]() |
property LocateSmartRefresh: Boolean Read FLocateSmartRefresh Write FLocateSmartRefresh; |
![]() |
property LookUpCache: Boolean Read FLookUpCache Write SetFLookUpCache; |
![]() |
property LookUpDisplayedRecordsOnly: Boolean Read FLookUpFieldsDisplayedRecordsOnly Write SetFLookUpFieldsDisplayedRecordsOnly; |
![]() |
property LookupFilters: TSqlitePassFieldFilters read FLookupKeyFieldFilters write FLookupKeyFieldFilters; |
![]() |
property LookupMoveState: TGetResult read GetLookupMoveState; |
![]() |
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 OnFilterRecord : TSqlitePassDatasetFilterRecordEvent read FOnFilterRecord write FOnFilterRecord; |
![]() |
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 ReadOnly: Boolean Read GetFReadOnly Write SetFReadOnly default False; |
![]() |
property RecordsCacheCapacity: TSqlitePassRecordsCacheCapacity Read FRecordsCacheCapacity Write FRecordsCacheCapacity; |
![]() |
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 CompareBookmarks(Bookmark1, Bookmark2: TBookmark): Integer; override; |
Compares two bookmark and returns
|
![]() |
Function CreateBlobStream(Field: TField; Mode: TBlobStreamMode): TStream; override; |
Classic TDataset behavior |
![]() |
Function GetFieldData(Field: TField; Buffer: Pointer): Boolean; override; |
function TDataset.GetFieldData(Field: TField; Buffer: Pointer): Boolean; The Field parameter is the field for which the value needs to be retrieved We send back the needed value in the buffer. Returns False if a null value was retrieved |
![]() |
function Locate(const KeyFields: String; const KeyValues: Variant; Options: TLocateOptions): Boolean; overload; override; |
The Locate function works as the classic one, with the same parameters, but has extended features to provide navigation in Located records with LocateFirst, LocateNext, LocatePrior, LocateLast, LocateRecordCount |
![]() |
function Locate(const LocateStmt: String; Options: TLocateOptions): Boolean; reintroduce; overload; |
![]() |
function LocateFirst: Boolean; |
Moves to the first record matching Locate parameters |
![]() |
function LocateLast: Boolean; |
Moves to the last record matching Locate parameters |
![]() |
function LocateNext: Boolean; |
Moves to the next record matching Locate parameters. |
![]() |
function LocatePrior: Boolean; |
Moves to the prior record matching Locate parameters |
![]() |
function Lookup(const KeyFields: String; const KeyValues: Variant; const ResultFields: String): Variant; override; |
Implementation of the classic TDataset.Lookup function |
![]() |
function LookupEx(const LookupStmt: String; const ResultFields: String; const LookUpResultMaxRecordCount: integer = 0): Variant; overload; |
The second |
![]() |
function LookupEx(const KeyFields: String; const KeyValues: Variant; const ResultFields: String; const LookUpResultMaxRecordCount: Integer = 0): Variant; overload; |
LookupEx function is a extension of classic lookup function in order to provide 'multiple rows' lookup results. It has got two syntaxes : The first syntaxe works as quite the sames parameters as the TDataset.Lookup classic one, but has extended features to provide navigation in LookedUp records with LookupFirst, LookupNext, LookupPrior, LookupLast. Additional Parameters : LookUpResultMaxRecordCount is used to limit the number of records returned by the Lookup function in order to improve speed with large tables. Note : Strings case sensitive lookup is set by the lookupFilters.Options property |
![]() |
function LookupFirst(var LookupResult: Variant): Boolean; |
Moves to the first record matching lookup parameters |
![]() |
function LookUpLast(var LookupResult: Variant): Boolean; |
Moves to the last record matching lookup parameters |
![]() |
function LookupNext(var LookupResult: Variant): Boolean; |
Moves to the next record matching lookup parameters |
![]() |
function LookupPrior(var LookupResult: Variant): Boolean; |
Moves to the prior record matching lookup parameters |
![]() |
Function AllocRecordBuffer: PRecBuffer; override; |
![]() |
function FindRecord(Restart, GoForward: Boolean): Boolean; override; |
![]() |
Function GetBookmarkFlag(Buffer: PRecBuffer): TBookmarkFlag; override; |
Procedure InternalMoveToBookmark(Bookmark: Pointer); |
![]() |
Function GetCanModify: Boolean; override; |
![]() |
function GetFieldClass(FieldType: TFieldType): TFieldClass; override; |
—— ——- |
![]() |
Function GetParamsCount: Integer; |
![]() |
Function GetRecNo: Integer; override; |
![]() |
Function GetRecord(Buffer: PRecBuffer; GetMode: TGetMode; DoCheck: Boolean): TGetResult; override; |
![]() |
Function GetRecordCount: Integer; override; |
—– Records infos —– |
![]() |
Function GetRecordSize: Word; override; |
Ok v1.00 |
![]() |
Function IsCursorOpen: Boolean; override; |
![]() |
Procedure ApplyChanges; |
—– Apply or Cancel records modification if WriteMode is wmPostpone —– |
![]() |
procedure CloseBlob(Field: TField); override; |
Classic TDataset behavior |
![]() |
Procedure EmptyTable; |
![]() |
procedure GetFieldList(List: TList; const FieldNames: string); |
Override the TDataset.GetFieldList method to accept quoted field names |
![]() |
Procedure Index; |
Indexes the dataset in memory, using the fields and |
![]() |
Procedure Refresh; |
—– —– |
![]() |
procedure RefreshLocate; |
![]() |
Procedure SetFieldData(Field: TField; Buffer: Pointer); override; |
seealso(GetFieldData) |
![]() |
Procedure Sort; |
Sorts the dataset using the fields and |
![]() |
procedure AllocateBLOBPointers(Buffer: pAnsiChar); |
—– Blobs —– |
![]() |
Procedure ClearCalcFields(Buffer: PRecBuffer); override; |
—– —– |
![]() |
Procedure DefineProperties(Filer: TFiler); override; |
![]() |
procedure DoOnNewRecord; override; |
![]() |
procedure FreeBlobPointers(Buffer: pAnsiChar); |
![]() |
Procedure FreeRecordBuffer(var Buffer: PRecBuffer); override; |
![]() |
procedure FreeRecordPointers(Buffer: pAnsiChar); |
![]() |
Procedure GetBookmarkData(Buffer: pAnsiChar; Data: Pointer); override; |
Procedure SetBookmarkStr(const Value: TBookmarkStr); override; -> Keep the inherited |
![]() |
Procedure InternalAddRecord(Buffer: Pointer; Append: Boolean); override; |
—– Navigation and Editing —– |
![]() |
Procedure InternalCancel; override; |
![]() |
Procedure InternalClearFieldDefs; |
![]() |
Procedure InternalClose; override; |
![]() |
Procedure InternalDelete; override; |
![]() |
Procedure InternalEdit; override; |
![]() |
Procedure InternalFirst; override; |
![]() |
Procedure InternalGotoBookmark(ABookmark: Pointer); override; |
—– Bookmarks —– |
![]() |
Procedure InternalHandleException; override; |
—– Miscalleous —– |
![]() |
Procedure InternalInitFieldDefs; override; |
![]() |
Procedure InternalInitIndexDefs; |
![]() |
Procedure InternalInitRecord(Buffer: PRecBuffer); override; |
![]() |
procedure InternalInsert; override; |
![]() |
Procedure InternalLast; override; |
![]() |
Procedure InternalOpen; override; |
![]() |
Procedure InternalPost; override; |
![]() |
Procedure InternalRefresh; override; |
![]() |
Procedure InternalSetToRecord(Buffer: PRecBuffer); override; |
![]() |
Procedure Loaded; override; |
—– Override methods from TDataset —– |
![]() |
Procedure Notification(AComponent: TComponent; Operation: TOperation); Override; |
![]() |
Procedure ReadParamData(Reader: TReader); |
![]() |
Procedure RefreshActive; |
Fetch data from physical Database |
![]() |
Procedure RefreshFilteredRecords; |
—– Filtering —– |
![]() |
Procedure SetBookmarkData(Buffer: pAnsiChar; Data: Pointer); override; |
![]() |
Procedure SetBookmarkFlag(Buffer: PRecBuffer; Value: TBookmarkFlag); override; |
From TDataset |
![]() |
procedure SetFiltered(Value: Boolean); override; |
![]() |
procedure SetFilterOptions(Value: TFilterOptions); override; |
![]() |
procedure SetFilterText(Const Value: String); override; |
![]() |
Procedure SetParamsList(Value: TParams); |
—– Params —– |
![]() |
Procedure SetRecNo(Value: Integer); override; |
![]() |
Procedure UpdateIndexDefs; override; |
![]() |
Procedure UpdateInternalFieldsInfos; |
![]() |
Procedure UpdateParamsList; |
![]() |
Procedure WriteParamData(Writer: TWriter); |
![]() |
property AfterCancel; |
![]() |
property AfterClose; |
![]() |
property AfterDelete; |
![]() |
property AfterEdit; |
![]() |
property AfterInsert; |
![]() |
property AfterOpen; |
![]() |
property AfterPost; |
![]() |
property AfterScroll; |
![]() |
property AutoCalcFields; |
Classic dataset behavior |
![]() |
property BeforeCancel; |
![]() |
property BeforeClose; |
![]() |
property BeforeDelete; |
![]() |
property BeforeEdit; |
![]() |
property BeforeInsert; |
![]() |
property BeforeOpen; |
— |
![]() |
property BeforePost; |
![]() |
property BeforeScroll; |
![]() |
property CalcDisplayedRecordsOnly: Boolean Read FCalcDisplayedRecordsOnly Write SetFCalcDisplayedRecordsOnly; |
Enable or Disable the persistent lookupfields |
![]() |
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 read only. 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 Filter; |
This dataset allows many kinds of filtering features that will be applied in this priority to the retrieved data :
As described, the The goal of the 2nd part is to provide filtering on calculated fields The 1st part : follows the classic dataset Example 2 : '=' operator has a special syntax supporting multiple values separated with comma MyDataset.Filter := MyField1 = 1, 10, 20, 30; MyField2 <> 5; MyField7 NotNull; For Boolean fields ComparisonOp : '=' Value : True or False Example 1 : MyDataset.Filter := MyField1 = True; MyField2 = False; For Text fields (including Memo) ComparisonOp : '=, <>, >, >=, <=, <, Null, NotNull' '=' and '<>' accepts '%' or '*' wildcard char. You can use *YourText or %YourText* or YourText% as TextPattern Example 1 : MyDataset.Filter := MyField1 = %Pasc%; MyField3 NotNull; For Date, Time, DateTime fields ComparisonOp : '=, <>, >, >=, <=, <, Null, NotNull' Value = numeric or empty (with Null and NotNull) DateFormat : #DD-MM-YYYY# TimeFormat : #hh:mm:ss[.zzz]# DateTimeFormat : #DD-MM-YYYY hh:mm:ss[.zzz]# Note : '#' can be replaced by single or double quote Example 1 : MyDataset.Filter := MyField1 = #22-02-2008#; MyField3 NotNull; |
![]() |
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 FilterMode: TSqlitePassFilterMode Read FFilterMode Write FFilterMode; |
Can take one of the following values :
See also
|
![]() |
property FilterOptions; |
foCaseInsensitive and foNoPartialCompare applies both to SQL and Internal Filters. You can also override the general setting, if you change the LocateFilters.Options, LookupFilters.Options, LookupFieldFilters.Options or Filters.Options properties |
![]() |
property FilterRecordLowerLimit: Integer Read FFilterRecordLowerLimit Write SetFFilterRecordLowerLimit; |
|
![]() |
property FilterRecordUpperLimit: Integer 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 Filters: TSqlitePassFieldFilters Read FFieldFilters Write FFieldFilters; |
A list of internal |
![]() |
property IndexDefs: TSqlitePassDatasetIndexDefs Read FIndexDefs Write FIndexDefs; |
The |
![]() |
property Indexed: Boolean Read FInMemoryIndexed Write SetFInMemoryIndexed; |
Determines whether or not the IndexedBy property is activated. |
![]() |
property IndexedBy: String Read FInMemoryIndexedBy Write SetFInMemoryIndexedBy; |
The
|
![]() |
property Indexes: TSqlitePassInMemoryIndexes Read FInMemoryIndexes Write FInMemoryIndexes; |
A list of In-Memory |
![]() |
property LocateFilters: TSqlitePassFieldFilters read FLocateFieldFilters write FLocateFieldFilters; |
![]() |
property LocateMoveState: TGetResult read GetLocateMoveState; |
Returns the state of the last move when locating a record |
![]() |
property LocateSmartRefresh: Boolean Read FLocateSmartRefresh Write FLocateSmartRefresh; |
When set to TRUE, Located records list is updated every time data is refetched from database. If FALSE, the located records list is not synchronized : Located records are lost when data is refetched |
![]() |
property LookUpCache: Boolean Read FLookUpCache Write SetFLookUpCache; |
Activate or disactivate the |
![]() |
property LookUpDisplayedRecordsOnly: Boolean Read FLookUpFieldsDisplayedRecordsOnly Write SetFLookUpFieldsDisplayedRecordsOnly; |
Enable or Disable the persistent lookupfields. You should turn on thos option if you need to sort lookupfields |
![]() |
property LookupFilters: TSqlitePassFieldFilters read FLookupKeyFieldFilters write FLookupKeyFieldFilters; |
![]() |
property LookupMoveState: TGetResult read GetLookupMoveState; |
Returns the state of the last lookup move |
![]() |
property LookUpSmartRefresh: Boolean Read FLookUpSmartRefresh Write FLookUpSmartRefresh; |
Automatically Resfreshes the Lookup Results when dataset is changed or refetch from database |
![]() |
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; |
When set to TRUE, the dataset will try to automatically open the master dataource if necessary |
![]() |
property OnCalcFields; |
![]() |
property OnDeleteError; |
![]() |
property OnEditError; |
![]() |
property OnFilterRecord : TSqlitePassDatasetFilterRecordEvent read FOnFilterRecord write FOnFilterRecord; |
Property OnExportProgress: TSqlitePassDatasetExportProgressEvent Read FOnExportProgress Write FOnExportProgress; Property OnImportProgress: TSqlitePassDatasetImportProgressEvent Read FOnImportProgress Write FOnImportProgress; |
![]() |
property OnNewRecord; |
![]() |
property OnPostError; |
![]() |
property ParamCheck: Boolean Read FParamCheck Write FParamCheck; |
Not used - TODO |
![]() |
property ParamCount: Integer read GetParamsCount; |
To be properly implemented |
![]() |
property Params: TParams read FParams Write SetParamsList Stored False; |
Not used - TODO |
![]() |
property ReadOnly: Boolean Read GetFReadOnly Write SetFReadOnly default False; |
Classic Dataset behavior |
![]() |
property RecordsCacheCapacity: TSqlitePassRecordsCacheCapacity Read FRecordsCacheCapacity Write FRecordsCacheCapacity; |
Set the number of records that can fit within one memory bloc before the need to alLookup a new records memory bloc. Using a larger |
![]() |
property Sorted: Boolean Read FSorted Write SetFSorted; |
Determines whether or not the IndexedBy property is activated. |
![]() |
property SortedBy: String Read FSortedBy Write SetFSortedBy; |
The IndexedBy property always takes a SQL 'ORDER BY' clause but without the 'ORDER BY' expression at the begining |
![]() |
property SortMode: TSqlitePassSortMode Read FSortMode Write SetFSortMode; |
Can take one of the following values :
See also
|
![]() |
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; |
The internal schema of the current SQL statement. It gives you access to advanced information - read only |
![]() |
property VersionInfo: TSqlitePassDatasetVersionInfo Read FVersionInfo Write FVersionInfo; |
Returns the dataset component version number |
![]() |
property WriteMode: TSqlitePassWriteMode Read FWriteMode Write SetFWriteMode; |
need to write doc... |