Unit rDBFilter

Description

rDBFilter provides filtering functions and universal dialog for user definition of filter string.

Full functional demo

Overview

Classes, Interfaces, Objects and Records

Name Description
Class TrDBFilterForm filtering functions and universal dialog for user definition of filter string

Functions and Procedures

function FilterRec(const DBGrid: TDBGrid; SortList: boolean = false): boolean; overload;
function FilterRec(const DataSet: TDataSet; SortList: boolean = false): boolean; overload;
function CompoundFilterString(const DBGrid: TDBGrid; var FilterStr: string; PSFile: TPropSaveFile; SQLFormat: boolean): boolean; overload;
function CompoundFilterString(const DataSet: TDataSet; var FilterStr: string; PSFile: TPropSaveFile; SQLFormat: boolean): boolean; overload;
function FilterRecSorted(const DBGrid: TDBGrid): boolean; overload;
function FilterRecSorted(const DataSet: TDataSet): boolean; overload;
function SetFilterString(D: TDataSet; Filter: string; ShowError: boolean = true): boolean;
procedure ClearFilter(const DBGrid: TDBGrid); overload;
procedure ClearFilter(const DataSet: TDataSet); overload;
function GetFilterCond(Field: TField; Value: string; IsNull: boolean): string;
function FilterByField(Field: TField; FilterJoin: TFilterJoin = fjNone): boolean;
function FilterBySel(const DBGrid: TDBGrid; FilterJoin: TFilterJoin = fjNone): boolean;
function NegateFilter(const DBGrid: TDBGrid): boolean; overload;
function NegateFilter(const DataSet: TDataSet): boolean; overload;

Variables

rDBFilterForm: TrDBFilterForm;

Description

Functions and Procedures

function FilterRec(const DBGrid: TDBGrid; SortList: boolean = false): boolean; overload;

Show DBFilter dialog and set filter for DBGrid (Columns collection is used)

function FilterRec(const DataSet: TDataSet; SortList: boolean = false): boolean; overload;

Show DBFilter dialog and set filter for Dataset (Fields collection is used)

function CompoundFilterString(const DBGrid: TDBGrid; var FilterStr: string; PSFile: TPropSaveFile; SQLFormat: boolean): boolean; overload;

Show DBFilter dialog and set FilterStr parameter for DBGrid (Columns collection is used), filter is not activated

function CompoundFilterString(const DataSet: TDataSet; var FilterStr: string; PSFile: TPropSaveFile; SQLFormat: boolean): boolean; overload;

Show DBFilter dialog and set FilterStr parameter for Dataset (Fields collection is used), filter is not activated

function FilterRecSorted(const DBGrid: TDBGrid): boolean; overload;

only for backward compability

function FilterRecSorted(const DataSet: TDataSet): boolean; overload;

only for backward compability

function SetFilterString(D: TDataSet; Filter: string; ShowError: boolean = true): boolean;

auxilary functions moved to rdbtool unit, keep here only for compability

procedure ClearFilter(const DBGrid: TDBGrid); overload;
 
procedure ClearFilter(const DataSet: TDataSet); overload;
 
function GetFilterCond(Field: TField; Value: string; IsNull: boolean): string;
 
function FilterByField(Field: TField; FilterJoin: TFilterJoin = fjNone): boolean;
 
function FilterBySel(const DBGrid: TDBGrid; FilterJoin: TFilterJoin = fjNone): boolean;
 
function NegateFilter(const DBGrid: TDBGrid): boolean; overload;
 
function NegateFilter(const DataSet: TDataSet): boolean; overload;
 

Variables

rDBFilterForm: TrDBFilterForm;
 

Author

Created

Sep 2002

Last Modified

Apr 2017


Generated by PasDoc 0.15.0.