Unit rDBFind

Description

rDBFind provides universal dialog for record lookup in DBGrid or Dataset. Supports lookup in Master-Detail datasets.

Full functional demo

Overview

Classes, Interfaces, Objects and Records

Name Description
Record TFindDefDetailRec define record for master-detail searching
Class TrDBFindForm universal dialog for searching in grid or database

Functions and Procedures

function FindRec(const DBGrid: TCustomDBGrid; SortList: boolean = false): boolean; overload;
function FindRec(const DataSet: TDataSet; SortList: boolean = false): boolean; overload;
function FindRecMD(const DBGrid: TCustomDBGrid; MasterSource: TDataSource; const MasterField, DetailField: string; ChangeMasterDetailProc: TChangeMasterDetailProc; SortList: boolean = false): boolean; overload;
function FindRecMD(const DataSet: TDataSet; MasterSource: TDataSource; const MasterField, DetailField: string; ChangeMasterDetailProc: TChangeMasterDetailProc; SortList: boolean = false): boolean; overload;
function FindRecDetails(const DBGrid: TCustomDBGrid; const FindDefDetailArr: TFindDefDetailArr; SortList: boolean = false): boolean; overload;
function FindRecDetails(const DataSet: TDataSet; const FindDefDetailArr: TFindDefDetailArr; SortList: boolean = false): boolean; overload;
function FindRecSorted(const GridOrDataSet: TObject): boolean;
function FindRecMDSorted(const GridOrDataSet: TObject; MasterSource: TDataSource; const MasterField, DetailField: string; ChangeMasterDetailProc: TChangeMasterDetailProc): boolean;

Types

TChangeMasterDetailProc = procedure(DataSet: TDataSet; MasterSource: TDataSource; ShowAll: boolean) of object;
TFindDefDetailArr = array of TFindDefDetailRec;

Variables

rDBFindForm: TrDBFindForm;

Description

Functions and Procedures

function FindRec(const DBGrid: TCustomDBGrid; SortList: boolean = false): boolean; overload;

show DBFind dialog for DBGrid (Columns collection is used)

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

show DBFind dialog for Dataset (Fields collection is used)

function FindRecMD(const DBGrid: TCustomDBGrid; MasterSource: TDataSource; const MasterField, DetailField: string; ChangeMasterDetailProc: TChangeMasterDetailProc; SortList: boolean = false): boolean; overload;

show DBFind dialog for detail DBGrid which use master-detail relationship

function FindRecMD(const DataSet: TDataSet; MasterSource: TDataSource; const MasterField, DetailField: string; ChangeMasterDetailProc: TChangeMasterDetailProc; SortList: boolean = false): boolean; overload;

show DBFind dialog for detail Dataset which use master-detail relationship

function FindRecDetails(const DBGrid: TCustomDBGrid; const FindDefDetailArr: TFindDefDetailArr; SortList: boolean = false): boolean; overload;

show DBFind dialog for DBGrid and list of details datasets

function FindRecDetails(const DataSet: TDataSet; const FindDefDetailArr: TFindDefDetailArr; SortList: boolean = false): boolean; overload;

show DBFind dialog for Dataset and list of details datasets

function FindRecSorted(const GridOrDataSet: TObject): boolean;

only for backward compability

function FindRecMDSorted(const GridOrDataSet: TObject; MasterSource: TDataSource; const MasterField, DetailField: string; ChangeMasterDetailProc: TChangeMasterDetailProc): boolean;

only for backward compability

Types

TChangeMasterDetailProc = procedure(DataSet: TDataSet; MasterSource: TDataSource; ShowAll: boolean) of object;

Callback procedure for changing of master-detail relationship during searching

TFindDefDetailArr = array of TFindDefDetailRec;

define array for master-detail searching

Variables

rDBFindForm: TrDBFindForm;
 

Author

Created

Sep 2002

Last Modified

Apr 2017


Generated by PasDoc 0.15.0.