Unit rDBComponents

Uses
Functions and Procedures
Constants
Variables

Description

rDBComponents units contains enhanced DB components which can replace standard DB components without loosing of set properties.

List of components in unit: TrDBRecordSelection, TrDBMoveButton, TrDBToolButton, TrDBEdit, TrDBEditDate, TrDBMemo, TrDBMemoEx, TrDBMemoCB, TrDBCheckBox, TrDBListBox, TrDBComboBox, TrDBLookupListBox, TrDBLookupComboBox, TrDBDateTimePicker, TrDBImage, TrDBLabel, TrDBBlob, TrDBCheckListBox, TrDBCheckListBoxEx

rDBComponents provide folowing functionality:
- can show Label in any possition, caption is DisplayLabel of field
- change background color and disable dropdown action (for listbox and combobox) if dataset is not in editing mode components
- rDBMoveButton provide function for moving in dataset records
- rDBDateTimePicker support of null value (show additional checkbox)
- rDBImage support JPG and PNG format, LoadFromFile and SaveToFile procedures, Copy/Paste to/from clipboard, introduce Zoom functions with scrollbars and buttons, introduce ImageEdit window for showing of image in independent window with function for editation of brightness and contrast
- mousewheel is working (for listbox and combobox)
- some bugs of standard components is fixed

Splash screen in demo version.

Overview

Classes, Interfaces, Objects and Records

Name Description
Class TrDBMoveButton Button which provides mooving and editing actions for linked dataset, enability of button is automaticaly set according ButtonType and Dataset state
Class TrDBToolButton ToolButton which provides mooving and editing actions for linked dataset, enability of button is automaticaly set according ButtonType and Dataset state
Class TDBBoundLabel TLabel subcomponent used by rDBComponents as field caption
Class TBoundLabel TrHTMLLabel or TLabel subcomponent, show additional user defined text in some db component
Class TBoundButtons subcomponent used by TrDBImage for showing of supplementary buttons
Class TBoundSpeedButton SpeedButton subcomponent used by some components for showing of supplementary buttons
Class TBoundListBox TListBox subcomponent used by other TrDBMemoCB
Class TBoundButtonedEdit TButtonedEdit subcomponent used by TrDBCheckListBox
Class TrDBEditButton internal button subcomponent used by TrDBEdit
Class TrDBEdit enhanced TDBEdit with bound label and left + right edit button
Class TrDBEditDate enhanced TrDBEdit allows fast entering of the date value by keyboard or by Month calendar; supported input formats - dd, dd/mm, dd/mm/yy, dd/mm/yyyy shortcuts - arrows Up/Down (optionaly Ctrl+Shift) to move date/month/year t = today, s = start of month, e = end of month, d,p = dropdown month calendar (if right button is visible)
Class TrDBMemo enhanced TDBMemo with bound label
Class TrDBListBox enhanced TDBListBox with bound label
Class TrDBComboBox enhanced TDBComboBox with bound label
Class TrDBLookupListBox enhanced TDBLookupListBox with bound label
Class TrPopupDataList TPopupDataList for TrDBLookupComboBox to access Paint method
Class TrDBLookupComboBoxHelper helper for TDBLookupComboBox to access TPopupDataList
Class TrDBLookupComboBox enhanced TDBLookupComboBox with bound label
Class TrDBCheckBox enhanced TDBCheckBox providing readonly color and caption loaded from selected field
Class TCheckBoxOnly checkbox subcomponent used by TrDBTimePicker
Class TrDBDateTimePicker DB version of TDateTimePicker with bound label and null value checkbox
Class TrDBImage DB version of TrImageZoom, provides zoom function with scrollbars and drag and move function
Class TrDBLabel DBVersion of TLabel, show db text from selected field as caption
Class TrDBMemoEx enhanced TrDBMemo component which provides highlighting of words in text according list of words or highlighting of text between start and stop tag, contain Format and Edit buttons with menu and user defined text in header
Class TrDBMemoCB enhanced TrDBMemo with combobox function
Class TCheckItem class to store one item in TrDBCheckListBox
Class TCheckItemList class to store list of TCheckItem in TrDBCheckListBox
Class TrDBCheckListBox DB version of TCheckListBox for n:m relationship
Class TrDBCheckListBoxEx enhanced TrDBCheckListBox component for n:m relationship which provides links to ListDataSource and ValueDataSource for automatic work with checklistbox
Class TChildLabel TLabel subcomponent used by TrDBBlob
Class TChildBtn Button subcomponent used by rDBBlob
Class TrDBBlob DB component for working with Blob fields, contains function for loading, saving and opening of any content in blob
Class TrDBRecordSelection DB Combobox for showing and selecting of active record, show active record and drop down show list of all records with possibility to select active record

Types

TrDBButtonType = (...);
TLabelPos = (...);
TBtnPos = (...);
TDBMemoOption = (...);
TDBMemoOptions = set of TDBMemoOption;
TGetLookupListItemHeight = procedure(Sender: TObject; Canvas: TCanvas; KeyField: TField; ListFields: string; var Height: integer) of object;
TGetLookupListItemProps = procedure(Sender: TObject; Canvas: TCanvas; RowIndex, ColIndex: integer; Selected: boolean; KeyField, ListField: TField; var Width: integer; Height: integer; var Text: string; ShowBmp: TBitmap; var DrawSeparatorTop: boolean; var DrawSeparatorBottom: boolean) of object;
TFormatType = (...);
TCheckItemsStyle = (...);
TFindItemsStyle = (...);
TLoadSaveItemList = procedure(Sender: TObject; Items: TCheckItemList) of object;
TBlobFileEvent = procedure(Sender: TObject; const FileName: string; FileSize: Int64) of object;
TLoadListEvent = (...);
TEditingState = (...);

Description

Types

TrDBButtonType = (...);

list of rDBMoveButton types

Values
  • btFirst
  • btPrior
  • btNext
  • btLast
  • btAdd
  • btInsert
  • btDuplic
  • btEdit
  • btDelete
  • btPost
  • btCancel
  • btEnaIfEdit
  • btEnaIfNew
  • btEnaIfBrowse
  • btEnaIfNotEmpty
  • btEnaIfCanModify
  • btEnaIfBrowseCanEdit
  • btEnaIfBrowseNotEmpty
TLabelPos = (...);

list of BoundLabel positions

Values
  • lpTopLeft
  • lpTopCenter
  • lpTopRight
  • lpLeftTop
  • lpLeftCenter
  • lpLeftBottom
TBtnPos = (...);

list of bound buttons position for TrDBImage

Values
  • bpTopLeft
  • bpTopRight
  • bpBottomLeft
  • bpBottomRight
  • bpLeftTop
  • bpLeftBottom
  • bpRightTop
  • bpRightBottom
TDBMemoOption = (...);
 
Values
  • moAllowSetFont
  • moAllowWordWrap
  • moAllowLoadSaveFile
TDBMemoOptions = set of TDBMemoOption;
 
TGetLookupListItemHeight = procedure(Sender: TObject; Canvas: TCanvas; KeyField: TField; ListFields: string; var Height: integer) of object;

event for user definition of lookup dropdown list width

TGetLookupListItemProps = procedure(Sender: TObject; Canvas: TCanvas; RowIndex, ColIndex: integer; Selected: boolean; KeyField, ListField: TField; var Width: integer; Height: integer; var Text: string; ShowBmp: TBitmap; var DrawSeparatorTop: boolean; var DrawSeparatorBottom: boolean) of object;

event for user definition of lookup dropdown list items

TFormatType = (...);

definition of possible formats in rDBMemoEx

Values
  • ftRTF
  • ftHTML
TCheckItemsStyle = (...);

list of possible items order for TrDBCheckListBox

Values
  • chsAllItems
  • chsCheckedFirst
  • chsCheckedOnly
TFindItemsStyle = (...);

list of possible items visibility for TrDBCheckListBox

Values
  • fisNone
  • fisFilter
  • fisSelect
TLoadSaveItemList = procedure(Sender: TObject; Items: TCheckItemList) of object;

event type for TrDBCheckListBox

TBlobFileEvent = procedure(Sender: TObject; const FileName: string; FileSize: Int64) of object;

event type used by TrDBBlob

TLoadListEvent = (...);

list of possible loading event used by TrDBRecordSelection

Values
  • leAfterOpen
  • leAfterDropDownFirst
  • leAfterDropDownAlways
  • leNever
TEditingState = (...);

list of possible state used by TrDBRecordSelection

Values
  • esDisable
  • esReadOnly
  • esAskBeforeMove
  • esPostBeforeMove

Author

Created

Oct 2006

Last Modified

Jan 2021


Generated by PasDoc 0.15.0.