Database tools and components package
Do you agree that standard DBGrid and DBNavigator is not the right components?
Are you tired of copying the same code to supply database function for each form with the DBGrid?
Download my DB package and you save a lot of time and hundreds lines of code.
Basic idea of this package is simple:
- there is set of universal actions, menus, toolbars and dialogs,
which can be used on any form in application with any dataset or DBGrid
- availability and visibility of this actions is dependent on properties of active grid
and current state of dataset
- all you need to do is to set rDBGrid properties in design time and
set active rDBGrid in runtime
Main parts of DB package are following:
rDBActions
is data module with set of universal actions, menus and toolbars:
Each action calls universal procedure or show universal dialog for data
of active rDBGrid and Dataset, so everything works without line of your code!
Action provides following functions:
- Searching, Sorting, Filtering, Exporting and Printing data
- Setting DBGrid and Columns properties including display format of data
- all DataSet Edit functions (Add, Edit, Duplicate, Delete, Post, Cancel)
See example of menus and dialogs. See detailed help how to use rDBActions.
rDBGrid
is enhanced DBGrid component which provides following functionality:
- shows check boxes for boolean fields (in font color)
- shows glyphs for memo fields and graphics fields (in font color)
- provides DatePicker for DateTime fields
- provides build-in editor for memo fields and long string fields
- provides build-in browser for graphics fields with BMP and JPG format
- can show text in some columns as URL link and can handle it
(http, mailto or userdefined links)
- can show any field as boolean checkbox with definable TRUE FALSE values
- can show any field as graphic symbols according field value
- shows complete text as hint for truncated text in cell and for memo field
- shows sort markers in title row (including multi column sorting)
- provides multiple line captions in title row with automatic word wrapping
- shows graphics in title row
- provides text line with selectable font and color in title row
- introduces events for change sorting and click on title cells or fixed column cell
- provides context menu for title row with calculation of
SUM, MIN, MAX, AVG, COUNT values for selected column
- can show odd rows by different color
- can show focus rectangle on whole active row
- provides automatic changing of columns width after resizing of grid
- provides enhanced functionality for choosing value in lookup fields and in columns with picklist
- provides functionallity for automatic filling of picklist according
existing values in the field
- provides automatic lookup functionality for non editing grid
- provides functionallity for linking to another grid to provide footer summary rows
- provides mouse wheel functionality
- introduces events for getting cell properties (font, background) and for drawing on active row
- introduces event for custom hint on any cell
- provides design time editor for quick setting of all new properties
Unlike other large DBGrid components rDBGrid is still TDBGrid descendant and increase size of EXE file only by cca 50 kB.
See more details about rDBGrid.
rDBGrid_MS
is enhanced rDBGrid component which provides all functionality for record multiselecting
including popup menu for fixed column:
rStringGridEd
is enhanced StringGrid component (non database grid), but with possibility to define columns
properties, editstyle (text, dropdown, checkbox, ellipsis), datatype (text, integer, numeric, datetime),
numeric format, min max values, colors etc...
rDBComponents
is sets of enhanced TDataControl components, as
- rDBEdit, rDBMemo, rDBCheckBox
- rDBListBox, rDBComboBox, rDBLookupListBox, rDBLookupComboBox
- rDBDateTimePicker
- rDBImage
- rDBLabel, rDBButton
Most of them provides following functionality:
- can show Label in selected position (Top, Left...), caption of this label is DisplayLabel of selected field or any own caption
- change background color and disable dropdown action (for listbox and combobox)
if dataset is not in editing mode
- some bugs of standard components are fixed
- mouse wheel is working (for listbox and combobox)
- rDBDateTimePicker support null value of date (show additional checkbox)
- rDBImage support BMP and JPG images and provide zoom with scrollbars, additional buttons for user friendly setting of zoom,
possibility to show/edit picture in independend window, cut, copy, paste, save as file, load from file functions
RTFReport2
RTFReport2 is non visual component which provides functionality for
generating reports according prepared RTF template file with special TAGs.
RTFReport2 use this template and fill data into it instead of TAGs.
RTF template can be modified easily by any RTF editor (i.g. MS Word).
RTFReport2 provides following functionality:
- multi dataset support (including master-detail functionality)
- exporting data from any type of field including graphic field with pictures
in BMP and JPG format
- generating BarCode image according Barcode value
- exporting data from one current record, from all records or from records according any conditions
- calculation and export of Sum, Min, Max, Avg dataset values
- calculation and export of any expression with +,-,*,/
- other inline functions (i.e. IF, IIF, INFO...)
See more details about RTFReport2
rDBRecView
is enhanced TCustomGrid component which provides functionality for displaying one dataset Record.
rDBrecView can display all type of fields including memo and graphics fields.
Each field can be displayed with different font style and color.
Design time editor can be used for setting of new properties.
|
|
