Unit rDBFind

DescriptionUsesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

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  
Class TrDBFindForm universal dialog for searching in grid or database

Functions and Procedures

function FindRec(const DBGrid: TDBGrid; SortList: boolean = false): boolean; overload;
function FindRec(const DataSet: TDataSet; SortList: boolean = false): boolean; overload;
function FindRecMD(const DBGrid: TDBGrid; 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: TDBGrid; 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: TDBGrid; 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: TDBGrid; 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: TDBGrid; 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;
 

Variables

rDBFindForm: TrDBFindForm;
 

Author

Created

Sep 2002

Last Modified

Apr 2017


Generated by PasDoc 0.13.0 on 2017-06-17 14:57:21