+ Multi-column mode in a DBVertGridEh
+ New features in TPivotGridEh
+ Added support for Delphi XE12
+ Multi-column mode in a DBVertGridEh
+ Visual elements for complex formatting in grid cells (LaControls)
+ Auto-highlighting links in a text cell of DBGridEh
* Support for Delphi versions 7, 2005, 2006 and 2007 has been discontinued
+ Design-Time edit windows added for TMemTableEh и TDBGridEh components under Lazarus IDE.
+ Support for printing and export to PDF file.
+ Acceleration of data loading to TXlsMemFileEh
+ Change highlighting of selected cells in DBGridEh
+ Dialogue for configuring the columns of the DBGridEh
+ Ability to display cells as buttons in DBGridEh
+ New properties in the TCellButtonEh class and new possibilities for displaying CellButtons in grid cells
+ New functions and features in the TDBSumList class
+ Methods for fast loading data from various DataSets into TMemTableEh.
+ Ability to load Xlsx files into the TXlsMemFileEh class.
+ The capabilities of the TXlsMemFileEh class have been expanded: Grouping of rows, Parameters of rows (Height, Visibility), Scale, Printing parameters, etc.
+ Extended version DBGridEh unloading procedures to Xlsx file.
+ Extended version of DBGridEh unloading procedures to a text file.
+ Search history in DBGridEh.SeachPanel.
+ High DPI monitors support.
+ Components for pivot data analysis: PivotGridEh, PivotDataSourceEh, PivotGridToolBoxEh
+ Components for planning time events and visual event management
+ SearchPanel - search and filter inplace mode, in the grid cell
+ Advanced drop-down filtering in the TDBComboboxEh and TDBLookupComboboxEh components
+ TPrintDBGridEh.OnPrintDataCell event.
+ New virtual methods in TDatasetFeaturesEh class for fine tuning when forming a filter string based on the filter set in DBGridEh.STFilter.
+ RowDetailPanel in DataGridEh
+ TreeView mode in DataGridEh with an internal list of data stored in a tree list
+ New drop-down filtering Form for columns of DateTime type with hierarchical separation by date / time sections
+ Added feature to group data in the DataGridEh using columns as a criterion of grouping.
EhLib.WinForms is a library of components and classes for Microsoft Visual Studio version 2012-2019.
A library is for creating visual applications in the Windows Forms API.
The current version of the library contains the following components:
- DataGridEh - Classic data grid for working and editing tabular information. An analog of the standard DataGridView grid.
- DataVertGridEh - Grid for working with tabular information, but rotated 90 degrees. Rows appear as fields in a table, and columns as entries in a list.
- DataPropertyGridEh - Grid for working with one record of the data table in vertical orientation. This is a DataVertGridEh with only one data column visible.
- TextBoxEh - A control for entering and editing text.
- MaskedTextBoxEh - A control for entering and editing text with restrictions on the format of the input data.
- NumericBoxEh - A control for entering and editing numeric data.
- DateTimeBoxEh - A control for entering and editing data of the Date, Time, Date and Time type.
- ComboBoxEh - A control for entering and editing text in a drop-down box for selecting values.
+ New type of data display in TPlannerEh - annual period by day.
+ In DBGridEh, the ability to save filters through the SettingsKeeper specified in the STFilter section.
+ Xlsx file generator.
+ Support for exporting DBGridEh and DBVertGridEh to Xlsx files in Lazarus in Win32 / 64 mode and CrossPlatform.
+ Support of Lazarus under Linux
+ Supports of ARC (Automatic Reference Counting) Delphi compilers
+ Compatibility with the CrossVCL library. Now you can compile your VCL project into a GUI application for OS X and Linux.
+ Technology for saving application settings - SettingsKeeper
+ Animation when moving columns in DBGridEh
+ Storage of the library's language resources with the ability to dynamically load
+ Auto-save PivotGrid layout when reloading data
+ Showing / hiding total rows/columns in PivotGridEh
+ New aggregate functions in PivotGridEh (Product, StDev, StDevp, Var, Varp)
+ Editing Cells in PivotGridEh
+ Dynamic calculation of found cells in SearchPanel
+ Functions for saving / restoring the column state to an INI file and Registry in DBVertGridEh
+ The filter icon in the DBGridEh header
+ New DropDown calendar with support for entering date and time
+ Highlight holidays, weekends and current day in TPlannerCalendarPickerEh component
+ Highlight current day and current time in TPlannerControlEh
+ AllowedOperations property in TPlannerControlEh
+ ReadOnly state for TPlannerControlEh and TPlannerDataItemEh
+ Time divider of 5, 6, 10, 15, 30 and 60 minutes in TPlannerDayViewEh and TPlannerWeekViewEh components
+ New properties and events in TPlannerXXXViewEh components (TPlannerDayViewEh, TPlannerWeekViewEh …)
+ CellButtons in columns of DBGridEh and rows DBVertGridEh to create buttons in cells of the grid operating without activation InplaceEditor text editor.
+ Search in a mode of “Begins with” in SearchPanel
+ Selecting of rows in DBGridEh.DataGrouping mode by pressing the group row in the indicator section
+ New features in SearchPanel of TDBGridEh to search by case sensitive, whole words and search only in one column
+ SearchPanel in TDBVertGridEh
+ Fill Right Empty part of TDBGridEh with cells like patterns
+ Event to customize and draw title cells including SupperTitle in MuliTitile mode.
+ Painting editor buttons (EditButtons) with a transparent background.
+ Bookmarks as pointers to records in TMemTableEh
+ Printing of DBVertGridEh, TPivotGridEh, TPlannerControlEh components
+ New event in TPlannerControlEh to customize SpainItem hint.
+ MRUList values can be formed automatically on the basis of a list of unique values in the DataSet
+ New events in the TDBGridEh.SearchPanel class
+ New components for planning and visual manage of time events.
+ New components to export DataSet to a text file and import from a text file
+ New property - RefLink in the DBGridEh.TColumnEh and DBVertGridEh.TFieldRowEh classes
+ Data transfer from DBGridEh and DBVertGridEh into clipboard with format compatible with MS Excel
+ Progressbar in the TPivotGridEh that shows a percent for data forming with possibility of interruption the process
+ Component that allow to hide other components on the Form at Design-Time
+ Export the contents of the TDBVertGridEh component into Xlsx file
+ DropDownForms technology - customizing droped down windows.
Typical DropDown window - is the list that appears in the TComboBox control when you click on the edit button with down arrow in the control.
New technology of DropDropForms allows you to create forms that appear and work similarly to the drop down list of TComboBox. These forms can be displayed by pressing one of the edit buttons within controls TDBEditEh, TDBNumberEditEh, TInplaceEditor in DBGridEh etc.
See detailed description of using DropDownForms in the document <About EhLib 6.2 Eng.doc>; Section - DropDownForms
and See an Example in the:
New properties to customize the drop-down Form are in the following classes:
In EditButtons for TDBNumberEditEh, TDBDateTimeEditEh, TDBComboBoxEh, TDBLookupComboBoxEh controls.
+ Added possibility to group rows into categories. See TDBVertGridEh.RowCategories property.
Assign category name in the property TFieldRowEh.CategoryName.
The rows can be grouped by: Category Title, Field Type or presence/absence of values in the current record.
+ Added possibility to sort the rows by the row captions. See property TDBVertGridEh.RowsSortOrder.
+ In DBGridEh at Design-Time it is allowed to create DB components and assign DataSource and DataSource.DataSet properties. Right-click above the Design-Time panel in the lower right corner of the Grid and select the menu to assign or create a required component.
* In the TIniPropStorageManEh.WritePropertiesText method the class that is used to write data to a file is changed. Instead of TIniFile the TMemIniFile is now used. It accelerated the write operation to the file, but changed the location of the file when IniFileName property is not specified a full path. The new version of the file will be saved in the current directory instead of the WINDOWS directory.
+ A new component TDBVertGridEh - DataSet Grid with the Vertical Orientation.
The component is used to display and edit a single record of DataSet in a vertical orientation.
Basic properties of the TDBVertGridEh:
Rows: TDBVerGridRows - A collection of items of TFieldRowEh type to display fields of a record. This is analogous to the Columns collection in TDBGridEh.
Options: TDBVHGridOptions - Configure basic properties of the vertical grid.
RowsDefValues: TFieldRowDefValuesEh - default values for line Grid row - TFieldRowEh. This is analogous of ColumnDefValues in TDBGridEh.
GridLineParams: TDBVertGridLineParamsEh - Color settings of the dividing lines invertical grid.
DataColParams: TDBVertGridDataColParamsEh - Settings of the column with data.
LabelColParams: TDBVertGridLabelColParamEh - Settings of the column with row label.
* Some constants and procedures are moved from the module DBGridEh to the DBAxisGridsEh .
+ Added a new global function to display a ObjectInspector-like Form.
+ Added an ability to change the size of RowDetailPanel by mouse at RunTime.
New properties in RowDetailPanel:
VertSizing: Boolean - Show an RowDetailPanel Splitter at the buttom of the RowDetailPanel.
MinHeight: Integer - Minimum height of the RowDetailPanel.
MaxHeight: Integer - Maximum height of the RowDetailPanel.
SizingBarBeveled: Boolean - Splitter area has a 3D border.
SizingBarHeight: Integer - The height of the Splitter.
+ Added new components to service the access through the technology DataDrivers.
TADOConnectionProviderEh - this component provides interaction between the TADODataDriver and TADOConnection in Design-Time and Run-Time. It contains a built-in TADOConnection component. It specifies the type of the SQL server for the correct operation of the extra operations on the server, such as the value of the incremental the table fields after inserting records, etc.
Similar functions are performed by next components:
TDBXConnectionProviderEh to services the access through the DBX Engine.
TIBXConnectionProviderEh to services the access through the IBX Engine.
TBDEConnectionProviderEh to services the access through the BDE Engine.
+ Dynamic properties of the EhLib components - DynProps.
A collection of elements that implement the dynamic properties of the components and class libraries. Every control of EhLib have DynProps collection.
In the DBGridEh component:
+ Added new sort marking images and the sort order now depends of the type of the field.
+ Added ability to customize colors of dividing lines and to define presence/absence of lines in different areas of the grid.
+ Added opportunity of flexible customizing of drawing the grid headers.
+ Added opportunity of flexible customizing of rendering the footer.
+ Added opportunity of flexible customizing of the drawing area SubtitleFilter.
+ Added the ability to display the image data in the cells from the Bolb fields in the various graphic formats.
+ Added the ability to display a graphical background Image.
+ Added ability of the advanced search and filtering of data.
+ Added an extra panel in the horizontal scroll bar.
+ Added opportunity of flexible adjustment of the group title (DataGrouping).
+ Added ability to display summing rows in groups.
+ Added opportunity of flexible adjustment for the HideDuplicates values.
+ Added a new option in display elements of the tree structure.
+ Added the ability to filter data in the drop-down lookup lists when typing text.
In the component MemTableEh
+ Added an ability to change the internal structure of the array without data loss.
+ Added an ability to save/load data from/to a file (s).
- Closed support for Delphi and C++ Builder versions lower than 7.
+ Added support of Embarcadero RAD Studio XE3.
* Fixed handling of the global variable OldStyleFlatBorder. In previous versions, if OldStyleFlatBorder = False (default value is False), then if TDBEditEh.Flat = True then drawing boundaries of TDBEditEh in Flat style never worked. In this version, if OldStyleFlatBorder = False then drawing boundaries of TDBEditEh in Flat style will work when the Windwos is in the Classic style and drawing Flat border will not work when the Windwos is in Themed environments and application use Themes.
+ Added a Images property in the class TEditButtonEh (TDBEditEh.EditButtons[i].Images) of a TEditButtonImagesE type.
TEditButtonImagesEh = class(TPersistent)
published property NormalImages: TCustomImageList;
property HotImages: TCustomImageList;
property PressedImages: TCustomImageList;
property DisabledImages: TCustomImageList;
property NormalIndex: Integer;
property HotIndex: Integer;
property PressedIndex: Integer;
property DisabledIndex: Integer;
Now it is allowed to draw Images from ImageList in EditButtons of Edit controls and columns of TDBGridEh. Images are drawn when TEditButtonEh.Style = ebsGlyphEh and TDBEditEh.EditButtons[i].Images.NormalImages is assigned.
+ Added EmptyDataInfo property in DBGridEh. If this property is enabled and DataSet is Active and it contains no data, then DBGridEh draws <No data> text in the center of the client area. You can specify the inscription for each DBGrid or set a global variable DBGridEhEmptyDataInfoText that is located in the module DBGridEh.
+ Added EmptyDataInfo property in the TDBEditEh, TDBNumberEditEh, TDBComboBoxEh, TDBLookupComboBoxEh. Use TDBEditEh.EmptyDataInfo.Text property to display the text that will be displayed in the Edit control when it contains no data.
+ Added standart property Touch (supported in Delphi 2010 and higher) for DBGridEh, TDBEditEh, TDBNumberEditEh, TDBComboBoxEh, TDBLookupComboBoxEh, TDBDateTimeEditEh.
+ Added the ability in design-time to open the Edit buttons collection editor (EditButtons) in TDBEditEh, TDBNumberEditEh, TDBComboBoxEh, TDBLookupComboBoxEh, TDBDateTimeEditEh controls. A menu item to open the collection is in the context menu of the component that opens on the right mouse button.
+ In TDBCheckBoxEh added the ability to set Empty value ('') for properties ValueChecked, ValueUnchecked. This allows you to set the state of CheckBox for Null value of DB field.
+ In DBGridEh added OnDataGroupGetRowParams event. The event is used to customize information for group records (when Grid works in data grouping mode - Grid.DataGrouping.Active = True). In the event you can specify color, font, text and pictures for the group row.
+ In the module DBGridEhImpExp added a global procedure - ExportDBGridEhToOleExcel. The procedure is designed to export data from DBGridEh to MS Excel. The procedure uses OLE to export data which means the MS Excel must be installed on the computer to allow this procedure work.
+ At design-time a context menu of TDBGridEh component displays information about the version of the library. + Added global procedure - DrawProgressBarEh. The procedure allows you to draw a picture in the form of a progress bar (ProgressBar). It can be used to display progress bar in grid cells. See example of use in the DEMOS\DEMO1 project.
+ Added support of Embarcadero RAD Studio XE2.
+ ThemeTitleFillElement property add to the TDBGridEhStyle class. property ThemeTitleFillElement: TGridThemeTitleFillElementEh; TGridThemeTitleFillElementEh = (gtfeHeaderItemEh, gtfeSplitButtonEh); This property defines Themes element that will be used to fill the background
the grid titles when property TDBGridEh.Flat = False.
* TDBGridEh.Flat property has no effect of filling of then title background under RAD Studio XE2 when TStyleManager.IsCustomStyleActive is True. In this case the grid fills titles using Themes style that is defined by DBGridEhDefaultStyle.ThemeTitleFillElement property.
* The filling of the grid titles uses thHeaderItem Theme style rather then ttbSplitButton style from version EhLib 5.5. Set global property DBGridEhDefaultStyle.ThemeTitleFillElement to gtfeSplitButtonEh for filling the title in the old style.
+ In DBGridEh. Checkboxes can be shown in the indicator column. Checkboxes is used to select records in the Grid.
+ In DBGridEh. IndicatorOptions property of TDBGridEhIndicatorOptions type was added.
gioShowRowIndicatorEh - have same meaning as dgIndicator in Options.
gioShowRecNoEh - have same meaning as dghShowRecNo in OptionsEh.
gioShowRowselCheckboxesEh - show checkboxes in the indocator column.
+ In MemTableEh. The principle of storing data for Calculated and Lookup fields was changed. Now values of these fields are stored in a special buffer for each record, and they are not recalculated each time when the data in the grid is repainted or scrolled. It allows to increase speed of showing data of Lookup and Calculated fields in the DBGridEh.
* Changes in the MemTableEh. If the MemTableEh is connected to DataDriver and fields are created in Design-Time (as Persistent Field Components),
then the MemTableEh creates internal structure of records taking description from Persistent Fields rather than taking structure from the DataDriver.
+ Added support of Embarcadero RAD Studio XE
+ Added Options property in MemTableEh of TMemTableOptionsEh type.
TMemTableOptionsEh = set of TMemTableOptionEh;
TMemTableOptionEh = (mtoTextFieldsCaseInsensitive);
mtoTextFieldsCaseInsensitive - Defines whether string fields should be compared in a case-sensitive or case-insensitive manner when data is sorting and filtering.
+ Added printing of grouped data in TPrintDBGridEh when Grid.DataGrouping is active. Use TPrintDBGridEh component to print and preview data.
+ Added CommandTimeout property in TADOCommandEh component.
+ Added feature to group data in the DBGridEh using columns as a criterion of grouping.
* The type of RowPanel property was changed. Instead of Boolean type, now it is an object property with subproperies:
Active: Boolean - Defines if it is possible to place cells under each over and if every propetry can have personal hight.
+ NavKeysNavigationType: defines the order of navigation over cells in the grid when keys Up, Down, Left, Right are pressed.
+ TabNavigationType: defines an order of going through cells of the grid by Tab key
+ A program for automatically installing library in Delphi/C++ Builder IDE is added. In time of installation the program creates folder, copies files, compile required packages and register packages in the IDE.
+ crpRowPanelColPlacementEh value is added in TColumnEhRestoreParam type, grpRowPanelColPlacementEh values is added in TDBGridEhRestoreParam type. Now, procedure RestoreGridLayout can restore cell positions then RowPanel is active.
+ Propery RowDetailPanelControl is added in public section. Use this property to add components on panel of detail information at RunTime. Use next code:
MyControl.Parent := DBGridEh1.RowDetailPanelControl;
+ Next subproperties are added in propery Grid.STFilter:
InstantApply: Boolean - defines if filter will be applied on chanching or clising of droped down list of filtered values (STFilter).
Location: TSTFilterLocationEh - defines the location STFilter. Under the title (stflUnderTitleFilterEh) or in the title
(stflInTitleFilterEh). When in the title then STFilter doesn't support edit line to enter filter expression.
+ The interface of droped down list of SubTitleFilter was changed. Now it is allowed to select requaried values in the list unsing checkboxes. The Item (Custom...) was added in the list of commands of filter droped down list. When selected, the simple filter dialog appeares to enter filter expression.
+ When the list of items for droped down filter list is formed, the current filter takes in account (Only when grid is conneccted to TMemTableEh).
+ New event added in Grid (TDBGridEh.OnFillSTFilterListValues), in the grid column (TColumnEh.OnFillSTFilterListValues) and in the TDBGridEhCenter (TDBGridEhCenter.OnFillSTFilterListValues). You can use event to fill list of droped down list of STFilter cell.
+ At design-time grid can show such components as DataSource, DataSet, DataDriver in its the bottom left part. These components can be selected in object inspector by mouse clicking. It allows to find quickly and select components which is connected to the grid.
+ New mode - RowPanel. In this mode, cells of grid can be placed under each other and can have individual height.
+ Grid can have special panel of detailed information for record. It is allowed to put any control from component palette on this panel. At run time, panel is hidden and user can open it by pressing on a '+' sign which is shown at the
begining of every row.
+ Grid can scroll data smoothly and by small steps of one pixel size. Grid can scroll data smoothly vertically and horizontally.
+ Hot track. Grid can highlight a cell or a row under mouse cursor.
+ Grid can show vertical line in gradient mode between data rows and bottom part of the grid.
+ In mode Column.AlwaysShowEditButton grid shows EditButtons in shadow mode. It doesn't irritate eyes by big amount of edit buttons in the grid.
+ New property EditButtonsShowOptions is added in the Grid of type TEditButtonsShowOptionsEh.
TEditButtonsShowOptionsEh = set of (sebShowOnlyForCurCellEh, sebShowOnlyForCurRowEh, sebShowOnlyWhenGridActiveEh, sebShowOnlyWhenDataEditingEh);
When Column.AlwaysShowEditButton is True, this property allows to customize, in which cases it is need to show EditButtons.
See screenshorts to view this features visually.
+ Added support of Embarcadero RAD Studio 2010
+ Added TextEditing property in the TColumnEh object. Use this property to ban showing text editor in the data column cell.
+ Added OnHintShowPause event in the TColumnEh object and TDBGridEh . Write this event to set duration pause before showing hint.
+ In TColumnEh object and TDBGridEh is added OnDataHintShow event. Write this event to set text, font, color, position and other parameters of hint window for every data cell in the the grid column. This event is call only if Grid.ShowHint is True.
+ In TColumnEh object and TDBGridEh added OnAdvDrawDataCell event. Write this event to draw data in the data cell of column. This event calls always regardless of Grid.DefaultDrawing property. Set Processed to true to define that you processed drawing in the event code. Otherwise grid will call default method for drawing. You can, if need, change parameters ARect and Params and call Grid.DefaultDrawColumnDataCell or you can leave Processed in False and don't call Grid.DefaultDrawColumnDataCell. In last case OnAdvDrawDataCell will work like OnGetCellParams event.
+ In TColCellParamsEh class added properties:
BlankCell: Boolean. Set this property to force show cell as a blank 3D cell.
SuppressActiveCellColor: Boolean. Set this property to suppress color of the active cell by the color that you set in the Background property.
TextEditing: Boolean. Set this property to ban showing text editor in the data cell.
TColCellParamsEh class is used in such events as OnGetCellParams and OnAdvDrawDataCell.
TColCellParamsEh class is used as a type of Params parameter in such events as OnGetCellParams and OnAdvDrawDataCell.
* Some bugfixes.
+ Added possibility to move the columns in the grid at Design-Time.
+ Added possibility to select the column in the Object Inspector by clicking on header of column.
+ Added DrawGraphicData property of Boolean type. When property is True, the grid draws image from TBlobField with BlobType = ftGraphic in graphic mode.
+ Added OnGetRowHeight event. Write this event to set height of every data row in the grid. The Event is caused when data is changed in DataSet. The Event is caused only when the grid is connected to TMemTableEh and MemTable
not in the TreeView mode.
+ Added dghAutoFitRowHeight in TDBGridEhOption type (OptionsEh). In this mode the grid calculates height of lines dynamically using text in data cells for a columns that TColumnEh.WordWrap = True. This mode works only when
grid is connected to TMemTableEh and MemTable not in mode TreeView. Grid updates the height of the lines not in all cases. For instance, grid does not update the height of the lines when you change Grid.Font property. In this case you need to call Grid.UpdateAllDataRowHeights where it is necessary.
+ In the mode when dgRowSelect is in Options, scrollbar works in smooth mode. (The Step of runner is not limited by the ñolumn width).
+ Added dghColumnMove and dghColumnResize in TDBGridEhOption type (OptionsEh). Now you can control of resizing and moving of columns separately.
+ Added dghShowRecNo in TDBGridEhOption type (OptionsEh). Set this value to show record number in the indicator column. It works only for DataSet which IsSequenced = True.
+ Drawing of 3D title cells in Flat mode is changed. When ThemeServices.ThemesEnabled = True, grid draws 3D cells in gradient style.
* Some bugfixes.
+ Added support of CodeGear RAD Studio 2009.
+ Added support of Delphi 2007.
+ Added IndicatorTitle property of TDBGridEhIndicatorTitle type:
The Upper left cell can react as button, draw the badge-triangle, and display the dropdown menu on mouse clickling ( with possibility of drawing global menu, which adjust using global property - DBGridEhCenter.IndicatorTitleMenus and IndicatorTitleMenus.OnBuildIndicatorTitleMenu).
IndicatorTitle property has a next subprotperty:
DropdownMenu: TPopupMenu - The Local dropdown menu, appearing when you press the upper left cell of the grid.
ShowDropDownSign: Boolean - Specifies whether to draw the badge-triangle. You can set this property to show that the pressing on upper-left cell will show the droped down menu.
TitleButton: Boolean - Specifies whether the upper left cell will act as button. Besides the DropdownMenu will be droped down only when TitleButton = True.
UseGlobalMenu: Boolean - Specifies whether the global DBGridEhCenter.IndicatorTitleMenus property will be use when building menu.
Added OnIndicatorTitleMouseDown event. Occurs when the mouse click on the upper left cell of grid. The Cell must be adjusted in state of working as buttons (IndicatorTitle.TitleButton = True). You can call DefaultIndicatorTitleMouseDown
method in this event to pass control to a global object - DBGridEhCenter.
Added OnBuildIndicatorTitleMenu event. Occurs when need to build list of menus before menu is shown. You can call DefaultBuildIndicatorTitleMenu method in this event to pass control to a global object - DBGridEhCenter.
Added OnCellMouseClick event. Occurs when mouse click in any cell of grid.
Event pass coordinates of the cell and offset of the mouse for upper left corner of the cell. You can call DefaultCellMouseClick method in this event to pass control to a global object - DBGridEhCenter.
+ In module DBGridEh.Pas appeared the new global object DBGridEhCenter of TDBGridEhCenter type. This object is intended to manage a behaviour of all objects of TCustomGridEh type or inherited from it. For instance, in DBGridEhCenter you can specify the list a menu to be appearing in the drop-down menu of the all grids when clicking on top left grid cell. Besides, you may write the event of this global object and it will be caused at activations of the similar event in any grid of the project.
Global object - DBGridEhCenter has a following properties and events:
IndicatorTitleMenus: Is the list of menu, which will be formed when clicking on upper left cell of grid is occured. This property of the global object will work for all grids, which IndicatorTitle.TitleButton = True. (itmVisibleColumnsEh, itmCut, itmCopy, itmPaste, itmDelete, itmSelectAll).
OnBuildIndicatorTitleMenu: Occurs when need to build list of menus before menu is shown.
OnCellMouseClick: Occurs when mouse click in any cell of grid.
OnIndicatorTitleMouseDown: Occurs when mouse click upper left cell of grid.
+ Added global variable - DBGridEhCenter. This variable controls the part of behaviour of the grids. You can set properties, or events of this variable to change the behaviour of all grids.
Changes in the other objects and procedures.
* The Corrections in ADODataDriverEh, SelectCommand, UpdateCommand... properties now have a TADOCommandEh type.
* The parameters of OnAssignCommandParameter and OnGetBackUpdatedValues have been changed in ADODataDriverEh object.
* All dfm files stores data in the text type.
* Fixed drawing lines in the gride when TColumnEh.HideDuplicated = True.
* Fixed memory leaks in the search box TDBGridEhFindDlg.
* Fixed error in the search dialogue, when invisible columns is present.
* Added support ftWideMemo.
* Fixed error of the recirculation in TPrintDBGridEh component when printing the rows with height above of the page height.
* Fixed error when developer create new TDataDriver component on Form using Popup menu 'Create DataDriver...' of TMemTableEh components.
+ In TDBLookupComboboxEh, Added support of the Memo fields.
* Fixed error of entering values from previous record (using Ctrl+') when DBGridEh is connected to TMemTableEh.
+ Added support of Borland Developer Studio 2006 (Delphi and C++ Builder).
* Fixed a error of the grid twinkling in the tree mode on opening a node.
* Fixed a error of filling a list of values in the filter when PickList and KeyList properties for the TColumnEh is filled.
* Some other bugfixes.
* This version does not support Delphi 4 and C++ Builer 4 anymore.
+ New components:
TMemTableEh - dataset, which hold all data in memory.
TDataDriverEh - Delivers records in TMemTableEh and processes changed records.
TSQLDataDriverEh, TBDEDataDriverEh, TIBXDataDriverEh, TDBXDataDriverEh
See detail info in AboutEhlib4_0.Txt of EhLib archive.
+ Added Action property or TBasicAction type in TEditButtonEh. So edit buttons
of the Edit controls can be associated with action.
+ In DBGridEh
When DBGridEh is connected to DataSet of TMemTable type it allows:
To view all data without moving active record.
To display a tree-type structure of TMemTable records.
To form list of values in dropdown list of SubTitle filter automatically.
+ Added support of Delphi 2005 (Under VCL.Win32 and VCL.NET).
+ Added Tooltips property in TDBEditEh, TDBDateTimeEditEh, TDBNumberEditEh, TDBLookupComboboxEh. Allows to show the whole text of the edit control in special hint window if text does not fit in visible area. Text is displayed when the mouse cursor situated above the edit control.
+ Added OddRowColor and EvenRowColor property to draw odd and even rows with different colors. It works only if sequence numbers are available for DataSet(DataSet.IsSequenced = True) and DataSet.RecNo return valid info.
+ Added dghRecordMoving value in TDBGridEhOption type (OptionsEh property).
Allows to move records in dataset. Record is moved by striking and moving mouse over indicator column. By default grid calls TDatasetFeaturesEh.MoveRecords, where code save values of record, delete record and insert new values in the position specified by RecNo.
+ Added OnMoveRecords event of TGridMoveRecordsEventEh type.
TGridMoveRecordsEventEh = function(Sender: TObject; BookmarkList: TStrings; ToRecNo: Longint; TreeLevel: Integer; CheckOnly: Boolean): Boolean of object;
BookmarkList is a list of bookmarks which need to move.
ToRecNo is a destination RecNo.
TreeLevel is a destination level in tree list, used only when grid connected to MemTableEh.
CheckOnly - determines whether the function have to return result, are there enabling to move BookmarkList to ToRecNo, but does not move BookmarkList.
+ Added OnSelectionChanged event. Occurs when multiselected area has been changed.
* In AdvTech\MemTableEh: Added possibility to filter data in TreeList mode; usage one array of records by the several datasets; moving records in TreeList in dghRecordMoving mode.
+ Added HighlightRequired property in TDBEditEh, TDBDateTimeEditEh, TDBNumberEditEh, TDBLookupComboboxEh and TColumnEh, TColumnDefValuesEh. Determines whether need to draw dotted red line under the text editor for empty required field (when TField.Required = True and field is empty).
+ Added OnCheckDrawRequiredState event in TDBEditEh, TDBDateTimeEditEh, TDBNumberEditEh, TDBLookupComboboxEh and TColumnEh. Write event need to change if need to draw a condition RequiredState (dotted red line under the text editor).
+ Added property Layout: TTextLayout in TColumnEh. Specifies the vertical placement of the text within the grid cell.
+ Added property HideDuplicates: Boolean in TColumnEh. Determines whether to hide duplicated values in the column.
* Changed image of 3D borders in grid when the Windows XP themes active in application.
* Procedure ExcecuteDBGridEhFindDialog is renamed to ExecuteDBGridEhFindDialog.
* In AdvTech\MemTableEh: Added indexes and autogenerating the list of values for dropdown box in filter cells.
EhLib team became the Borland Technology Partner.
+ Added support of Delphi 8 (VCL.NET).
+ Added property ToolTips in Footer and ColumnDefValues.Footer.
+ Added property SumValue: Variant in TColumnFooterEh.
+ Added property ShowImageAndText in TColumnEh. Allows to show Image from ImageList and field Text in grid cell simultaneously. Set ImageIndex in OnGetCellParams event.
+ Added property Images: TCustomImageList. Images from imagelist can appear at the left part of TDBEditEh, TDBDateTimeEditEh, TDBNumberEditEh or TDBLookupComboboxEh.
+ Added event OnGetImageIndex: TGetImageIndexEventEh.
TGetImageIndexEventEh = procedure(Sender: TObject; var ImageIndex: Integer) of object;
Event is called when Text or Value in TCustomDBEditEh is changed. Set new ImageIndex depending on Text or Value.
EhLib setup files for Evaluation version available for download in 'Downloads' area. Setup automatically deinstall previous version of EhLib packages from Delphi (BCB) IDE, install new version of packages and help files in IDE.
+ Added new form 'DBGridEhFindDlgs' - find dialog in DBGridEh. Dialog allows to find text in the grid: In specified column or on whole grid; From any part of field, Whole field or From beging of the field. Set new dghDialogFind value to OptionsEh to allows find dialog in DBGridEh. Default shortcut to show find dialog in the grid is 'Ctrl-F'. When dghIncSearch also included in the OptionsEh then first pressing 'Ctrl-F' enters the grid in the Increment Search mode and holding 'Ctrl' press 'F' again to show the find dialog.
+ Added dghDialogFind value to the TDBGridEhOption type (property OptionsEh).
+ Added KeyField, ListField, ListSource properties. Now you can adjust combobox in SubTitle Filter cell. If Column.STFilter.ListSource is not empty then grid will create combobox for such filter cell. ListSource defines the list of values in drop-down list, ListField defines field whose values are displayed in drop-down list, KeyField identifies the field in the ListSource dataset whose value will takes to build filter expression.
+ Added SupportsLocalLike property. Determines if the dataset supports 'Like' keyword in Filter property. Modules from DataService directory of EhLib archive rewrited to support this property.
+ Added AutoAdd property of Boolean type. Determines that the edit control will add new Text in MRUList automagically when control loses focus. Default value for property is True. You can use it (set to False) to fill MRUList manually, for instance from database table.
* Some bugfixes.
+ Added ability to fill cell by the value from previous record. You can use <Ctrl+'> key to do it.
+ Added dghDblClickOptimizeColWidth value to the TDBGridEhOption type (property OptionsEh). Adding this value to OptionsEh property allows grid to set optimal column width (to fit text in cells of column).
on double-click on ColSizing line.
+ Added ability to show special row (under title) where you can enter expressions in cells for filtering records in dataset. (Expression in the cell can look like: "1", ">=1", ">1 AND <=5", "%TestStr%")
When cursor reside in the filter cell they can press ENTER to apply filter.
For automatically filtering data in dataset need to add one of the units EhLib... (EhLibADO, EhLibBDE, EhLibCDS) to 'uses' clause of any unit of your project. Now EhLib have objects to filter data in the TClientDataSet, TQuery, TTable and TADOQuery. You have to write and register your own object to filter
data in DataSet that not present in this list or you can write TDBGridEh.OnApplyFilter event for every grid.
Added property - STFilter: TSTDBGridEhFilter with subproperties:
property Local: Boolean - grid does not use it, but object that perform filtering can determine whether it will filter locally in dataset or on the server (by adding filter expressions in SQL 'WHERE' clause).
property Visible: Boolean - Specifies whether the filter row is visible.
+ Added OnApplyFilter event.
+ Added ApplyFilter function in TDatasetFeaturesEh class.
+ Added new property - STFilter: TSTColumnFilterEh; with subproperties
DataField: String - Specifies the field name that use to filter data if Column.FieldName is not fit for it.
Visible: Boolean - Specifies whether user can enter expressions in filter row for this column.
ExpressionStr: String - text expression in StFilter cell.
Expression: TSTFilterExpressionEh - coded expression in StFilter cell.
EhLib home page is moved. Now, home page of ehlib is http://www.ehlib.com.
EhLib suppor e-mail is opened. firstname.lastname@example.org
EhLib forum is opened - http://groups.yahoo.com/group/EhLib
Deployed EhLib 3.1
* Changes in TRegPropStorageManEh:
'Key' property moved from 'published' to 'public' part.
(C++ Builder does not support HKEY type in published part).
Added RegistryKey property of TRegistryKeyEh type.
+ Added (in source included version only) preview version of the TMemTableEh component. Dataset, which hold all its data in memory, furthermore can fetch data from other dataset's, unload changes
back to dataset and support special interface, that allow to view all data without changing active record.
See detail info in AdvTech\MemTableEh\readme.txt dir.
+ In DBGridEh: Added support of IMemTableEh interface in DataSet that allow to view all data, without changing active record.
+ New values in TDateTimeKindEh type (property Kind).
TDateTimeKindEh = (dtkDateEh, dtkTimeEh, dtkDateTimeEh, dtkCustomEh);
+ Added EditFormat property. Now you can type custom date/time format using next format elements: 'YY', 'YYYY', 'MM', 'DD', 'HH', 'NN', 'SS'.
Library is divided to design-time and run-time packages.
EhLib[XX] - run-time package and DclEhLib[X] - design-time packages, where [XX] is digit number of VCL version:
 for Delphi 4,  for Delphi 5, etc; And EhLibB[XX] with DclEhLibB[XX] for C++ Builder.
Upon installation, all components is placed to the separate page in components palette with name - 'EhLib'.
Note that Delphi IDE does not move components to the new default place when you install new version of same component(s). So if you already has EhLib installed, then installation new (3.0) version does not move EhLib components to the 'EhLib' page on components palette. To force Delphi IDE to move compontes to the default place on components palette do next:
Open menu: Component->Configure Palette.
Select '[All]' line in Pages listbox.
Click 'Default Pages' button.
New componetns: TPropStorageEh, TIniPropStorageManEh, TRegPropStorageManEh.
Components realize technology to store components properties to/from settings storage such as ini files, registry etc.
+ Added (in source included version only) design-time ClientDataSet edit window.
See detail info in AdvTech\CDSDesign\readme.txt dir.
+ Added Windows XP themes support (Only under Delphi 7).
+ Added (in source included version only) preview restricted version of EhLibCLX - EhLib under Borland Component Library for Cross-Platform.
+ Added (in source included version only) preview version of technology to store components properties to/from settings storage such as ini files, registry etc.
See detail information at Detail information about DBClique Library
+ Added Delphi 7 support.
+ New units: CalculatorEh - TCalculatorEh, TPopupCalculatorEh
DbUtilsEh - Utilities to sort data in DataSet from DBGrid
EhLibADO - Register object that sort data in TADOQuery
EhLibBDE - Register object that sort data in TQuery
EhLibCDS - Register object that sort data in TCustomClientDataSet
+ Added possiblity to sort data in DataSet after sorting markers will be changed. You have to add dlgAutoSortMarkingEh to OptionsEh, set TColumnEh.Title.TitleButton to True for required columns, keep OnSortMarkingChanged event empty, add one of the units EhLib... (EhLibADO, EhLibBDE, EhLibCDS) to 'uses' clause of any unit of your project. Now EhLib have objects to sort data in TClientDataSet, TQuery and TADOQuery. You have to write and register you own object to sort data in DataSet that not present in this list.
+ Added SortLocal property in TDBGridEh. Objects that sort data in DataSet can use this property to determine how to sort data, on client or on server.
+ Changed highlight coloring in TDBGridEh for multiselected cells and active cell when TDBGridEh have not focus when color mode have more then 256 color. I recombinate you to use dgAlwaysShowSelection in Options and dghRowHighlight in OptionsEh. If you want to keep old method of highlighting for all grids set DBGridEhDefaultStyle.LuminateSelection to false (at run time).
In TDBNumberEditEh and TColumnEh
+ Added dropped down calculator in TDBNumberEditEh and TColumnEh for numbered fields (need set TColumnEh.ButtonStyle to cbsDropDown).
+ Added DisplayFormat and EditMask properties.
+ Added DisplayFormat property.
See detail information at Detail information about TBDEClientQueryEh component
+ Added MRUList property (Most recently used values) in all edit controls and TCloumnEh. If MRUList is Active then in time of edit text the special listbox will be dropded down where users can select last entered values. When user leave edit control or inplace editor in the grid the value will be added in MRUList.
MRUList: TMRUListEh = class(TPersistent)
property Active: Boolean - MRU list will drop down in time of edit text.
property CaseSensitive: Boolean - take into account char case.
property Items: TStrings - list of items.
property Limit: Integer - max count of items. Old will be deleted.
property Rows: Integer - Count of rows in dtop down window.
To distinguish MRU dropdown box from other, all other dropdown boxes have 3D border.
+ Added new component - TDBCheckBoxEh.
Can works as in data-aware mode as in usual not data-aware mode. If DataField and DataSource properties is not assigned then checkbox works in usual not data-aware mode.
Have Flat and AlwaysShowBorder properties to show in the flat mode.
In TDropDownBoxEh (TColumnEh.DropDownBox, TLookupComboBoxEh.DropDownBox) added property
+ ListSource of TDataSource type.
This property will be used when lookup inplace editor in the grid or LookupComboBox have focus. It allows to have different list of lookup list values for different records of master data.
+ Added OnAfterRecalcAll event. Event is call after SumList recalculate aggregated values.
+ Added OnSumListAfterRecalcAll event.
+ Added C++ Builder 6 support.
In TDBDateTimeEditEh and TDBComboBoxEh
+ Added OnCloseUp and OnDropDown events.
In TDBGridEhScrollBar class (DBGridEh.VertScrollBar, HorzScrollBar)
+ Added property ExtScrollBar: TScrollBar.
Now you can attach external scrollbars to the grid. DBGridEh.VertScrollBar can be show in three mode:
Always show, Never show, Auto show.
Use property DBGridEh.VertScrollBar.VisibleMode.
INCOMPATIBILITY: To be more look like DBGrid component the DBGridEh component select row (multiselect) on first mouse click when Options have dgMultiSelect value and AllowedSelections have not gstRectangle value.
+ Added properties WantTabs and WantReturns.
INCOMPATIBILITY: In TColumnEh all published properties moved to public section. New TDBGridColumnEh object added that inherited from TColumnEh and have properties in published section. TDBGridEh uses TDBGridColumnEh to create columns. You can have incompatibility if you inherit TColumnEh object. Use TDBGridColumnEh object now.
+ Dropdown box in TDBLookupComboBoxEh and TColumnEh for look fields now inherited from TCustomDBGridEh. Now dropdown box can have MultiTitle, can fit columns width to window width, can have column lines and row lines, allows to change column widths, can have sortmarkers in titles, have event that calls when user press title, allows to change characteristics of individual column.
RESTRICTION: In EhLIb compiled under Delphi 4 or CBuilder 4 dropdown box can not resize or move columns or click the titles.
+ Added new unit - DBLookupGrid.Pas, contains TPopupDataGridEh component that uses as Dropdown box in TDBLookupComboBoxEh and TColumnEh for look fields.
+ Added property DropDownBox of TColumnDropDownBoxEh type
TColumnDropDownBoxEh = class(TPersistent)
property AutoFitColWidths: Boolean;
property ColumnDefValues: TColumnDefValuesEh;
property Columns: TDBGridColumnsEh;
property Options: TDBLookupGridEhOptions;
property UseMultiTitle: Boolean;
using properties of DropDownBox property you can control dropdown box for inplace editor of columns that connected to lookup fields.
property AutoFitColWidths: Boolean;
property ColumnDefValues: TColumnDefValuesEh;
property Columns: TDBGridColumnsEh;
property Options: TDBLookupGridEhOptions;
property UseMultiTitle: Boolean;
in TLookupComboboxDropDownBoxEh object (TDBLookupComboboxEh.DropDownBox property)
In TColumnEh and TDBLookupComboboxEh
+ Added events
OnDropDownBoxCheckButton - Occurs to define is there title can be pressed.
OnDropDownBoxDrawColumnCell - Occurs when the dropdown box needs to paint a cell.
OnDropDownBoxGetCellParams - Occurs when the dropdown box needs to paint a cell.
OnDropDownBoxSortMarkingChanged - Occurs after changing sortmarker.
OnDropDownBoxTitleBtnClick - Occurs after clicking on title button.
Added new file EhLibConsts.Pas - contains resource of strings.
Added partially support of BiDirection.
Added partially support of the Double-Byte Character Set.
+ Added property FieldColumns;
property FieldColumns[const FieldName: String]: TColumnEh; default;
So you can use next syntax to access column by filed name: DBGridEh1['FieldName']
In TDBEditEh, TDBDateTimeEditEh, TDBComboBoxEh, TDBNumberEditEh and TColumnEh added property
+ EditButtons of TEditButtonsEh type.
Class TEditButtonsEh is a collection of TEditButton classes.
So the edit controls and columns can have several edit buttons.
In TDropDownBoxEh added property
+ SpecRow of TSpecRowEh type.
In TColumnEh added property
+ DropDownSpecRow of TSpecRowEh type.
TSpecRowEh = class(TPersistent)
property CellsText: String;
property Color: TColor;
property Font: TFont;
property Value: Variant;
property Visible: Boolean;
property ShortCut: TShortCut
property ShowIfNotInKeyList: Boolean;
TSpecRowEh represent the special row in dropDown box for lookup fields in column of DBGridEh and in TDropDownBoxEh class of TDBLookupComboboxEh component. This row will be active when lookup field or lookupcombobox have value equals specrow value or when value not in list of key value.
* In the OnButtonClick event for TDBComboBoxEh, TDBLookupComboboxEh, TDBDateTimeEditEh the Sender parameter is TEditButtonControlEh object. Use TEditButtonControlEh(Sender).Parent syntax to access the edit control whose button have been clicked.
EhLib 2.0 does not support Delphi 3 and C++ Builder 3.
+ For columns that attached to lookup Fields it support possibility of changing values if TField.KeyFields and TField.LookupKeyFields is kept a list of several names of fields (list is separated by semicolon).
+ In TDBGridEhOption type (OptionsEh propery) dghRowHighlight value is added - it allows to highlight current record.
+ Added crpDropDownRowsEh and crpDropDownWidthEh values in TColumnEhRestoreParam type, it allows to save and restore DropDownRows and DropDownWidth properties of TColumnEh in/from the registry or ini file.
+ Added property AllowedSelections: TDBGridEhAllowedSelections;
TDBGridEhAllowedSelections = set of (gstRecordBookmarks, gstRectangle, gstColumns, gstAll);
Defines what types of selection is available in grid. dgMultiSelect value in Options property also affects available of selection.
+ Added property ColumnDefValues: TColumnDefValuesEh
TColumnDefValuesEh = class(TPersistent)
defines default values for newly created colonies.
+ Added OnNotInList event. Operates when user enter a text not kept in the list of values. If this event is assigned then user is automatically allowed to enter a text not kept in the list. Event makes sense if row is based on lookup field or PickList is filled or PickList and KeyList is filled.
+ Added OnGetCellParams event:
TGetColCellParamsEventEh = procedure (Sender: TObject; EditMode: Boolean; Params: TColCellParamsEh) of object;
TColCellParamsEh = class
property State: TGridDrawState;
property Font: TFont read FFont;
property Background: TColo;
property Alignment: TAlignment;
property ImageIndex: Integer;
property Text: String read;
property CheckboxState: TCheckBoxState;
property ReadOnly: Boolean;
Requests the parameters of cell before draw/editing.
+ Added OnUpdateData event: TColCellUpdateDataEventEh = procedure(Sender: TObject; var Text: String; var Value: Variant; var UseText: Boolean; var Processed: Boolean) of object;
Operates when writing data from InplaceEditor in DataSet field. You can change text or value, UseText defines what parameter is used for writing: Text or Value. You may themselves write data to the field and sets Processed in True.
+ Added OnEditButtonClick event: TButtonClickEventEh = procedure(Sender: TObject; var Handled: Boolean) of object;
+ Added OnEditButtonDown event: TButtonDownEventEh = procedure(Sender: TObject; TopButton: Boolean; var AutoRepeat: Boolean; var Handled: Boolean) of object;
TopButton - when style of the button ebsUpDownEh, defines that pressed upper button. AutoRepeat - repeat events if mouse is keeping pressed.
* State Of working group operations goCount is changed. When in TDBSum installed by GroupOperation = goCount and FieldName <> '' that SumValue will contain an amount of records for which field <FieldName> is not Null.
* Component has changed an ancestor, so possible inconsistency of functioning with the preceding version.
+ Supports working with lookup fields that containing in TField.KeyFields and TField.LookupKeyFields properties the list of the several names of fields, in the same way possible enter a list of several names of fields in DataField and KeyField properties of combobox. List of field names must be separated by semicolon (For instance: 'CustNo;EmpNo').
+ Added OnButtonDown event: TButtonDownEventEh = procedure(Sender: TObject; TopButton: Boolean; var AutoRepeat: Boolean; var Handled: Boolean) of object;
TopButton - when style of the button ebsUpDownEh, defines that pressed upper button. AutoRepeat - repeat events if mouse is keeping pressed.
Added 4 new components:
TDBEditEh - to edit text values.
TDBDateTimeEditEh - to edit date or time values.
TDBComboBoxEh - to edit text values with capacity to select values from list.
TDBNumberEditEh - to edit numeric values.
Common features in all components:
Can works as in data-aware mode as in usual not data-aware mode. If DataField and DataSource properties is not assigned then component works in usual not data-aware mode.
Have Flat and AlwaysShowBorder properties to show in the flat mode.
Have Text (String type) and Value (Variant type) properties.
Moreover Value can accept Null value or:
String type for TDBEditEh and TDBComboBoxEh,
TDateTime, TDate, TTime, Double type for TDBDateTimeEditEh,
all numeric types for TDBNumberEditEh.
Have an OnUpdateData event that occurs before writing data in DataSet field or in internal variable when not data-aware mode. Event is call when component lose the focus or when DataSet send PostData event.
Individual features of components:
TDBEditEh, TDBComboBoxEh and TDBLookupComboboxEh have WordWrap propertiy to show and edit multiline text. Don't forget to hang up AutoSize propertiy if you want to change and fix a height of the control.
+ Added Delphi 6 support.
+ Added AlwaysShowBorder propery.
* Some bugfixes.
+ Added OnNotInList event. Event occurs when the user enters a value that isn't in the lookup list.
+ Added group operation goAvg to calculate average values.
+ Added OnBeforePrint and OnAfterPrint events to write specifyed action before or after grid have been printed/previewed.
+ Added possibility to set aggregate fields in footers at design time. So you can use more powerful mechanism of aggregate values imbedded in TClientDataSet component.
* Some bugfixes.
Added new component TDBLookupComboboxEh:
Provides all functionality of TDBLookupCombobox and adds several new features as follows:
Can have flat style.
Allows assign values as to KeyValue property just and to display Text property.
Allows to type (assign) values to Text property not contained in data list (Style = csDropDownEh).
Allows to hold KeyValue and Text as not affecting to each other values. Take effect when KeyField, ListField, ListSource, DataField and DataSource properties is empty.
Drop down list can:
Have sizing grip,
Automaticaly set width as sum of DisplayWidth of the list fields (Width = -1),
Automaticaly drops on user pressed the key.
Edit button can:
Show DropDown, Ellipsis or Bitmap image.
Have specified width.
Have additional events: OnKeyValueChanched, OnButtonClick.
+ In Flat mode shows edit buttons just as flat.
+ Added DropDownShowTitles property.
* Some bugfixes.
+ Added dghIncSearch and dghPreferIncSearch values in TDBGridEhOption type (property OptionsEh).
dghIncSearch value allows to do increment search in grid.
dghPreferIncSearch value determine that the grid prefer increment search to cell editing.
At run time you can use next key for increment searching:
Ctrl+F - to begin increment searching.
Ctrl+Enter - to search next matching.
Ctrl+Shift+Enter - to search prior matching.
If dghIncSearch in OptionsEh and column is read only then grid will set increment search mode automatically on first key press and will set normal mode after 1.5 sec.
+ Added Tag property. Tag has no predefined meaning. The Tag property is provided for the convenience of developers.
+ Added DropDownSizing property. Set DropDownSizing to True to allow users to resize dropdown lookup or picklist window.
* Some bugfixes.
Add-on for DOA (Direct Oracle Access)
Contains synchronous routines to open queries with possibility to cancel execution.
See detail information.
TPassthroughColumn class has been unloaded. In csDefault and csCustomized state uses the same class TColumnEh. It allows to inherit TDBGridEh class and add new properties in TColumnEh class.
+ Allows to show tooltips text for KeyImage based columns. When you adjust column properies to show bitmaps depending on field values you can fill also PickList propery by values of tooltip text.Set also Tooltips property to True and ShowHint property of DGBGridEh to True. At runtime by moving mouse above image will forces to show text from PickList in tooltips window.
+ Added property Orientation: TTextOrientationEh;
TTextOrientationEh = (tohHorizontal, tohVertical);
Allows to draw text vertically. Only single line text support for vertical orientation.
* Some bugfixes.
Added new unit "DBGridEhImpExp.pas" that containt objects and routines:
1. To export DBGridEh at next formats: Text, Csv, HTML, RTF, XLS and internal format for interchange between DBGridEh's (VCLDBIF).
procedure SaveDBGridEhToExportFile( ExportClass: TDBGridEhExportClass; DBGridEh: TCustomDBGridEh; const FileName: String; IsSaveAll: Boolean);
procedure WriteDBGridEhToExportStream( ExportClass: TDBGridEhExportClass; DBGridEh: TCustomDBGridEh; Stream: TStream; IsSaveAll: Boolean);
Where the ExportClass parameter is one of the next classes:
TDBGridEhExportAsText, TDBGridEhExportAsCsv, TDBGridEhExportAsHTML, TDBGridEhExportAsRTF, TDBGridEhExportAsVCLDBIF or TDBGridEhExportAsXLS.
IsSaveAll parameter indicates whether to export whole grid or only selection.
2. To import DBGridEh from Text and internal format (VCLDBIF).
procedure LoadDBGridEhFromImportFile( ImportClass: TDBGridEhImportClass; DBGridEh: TCustomDBGridEh; const FileName: String; IsLoadToAll: Boolean);
procedure ReadDBGridEhFromImportStream(ImportClass: TDBGridEhImportClass; DBGridEh: TCustomDBGridEh; Stream: TStream; IsLoadToAll: Boolean);
Where the ImportClass parameter is one of the next classes: TDBGridEhImportAsText, TDBGridEhImportAsVCLDBIF.
3. To Copy, Paste, Cut DBGridEh to/from clipboard.
procedure DBGridEh_DoCutAction(DBGridEh: TCustomDBGridEh; ForWholeGrid:Boolean);
procedure DBGridEh_DoCopyAction(DBGridEh: TCustomDBGridEh; ForWholeGrid:Boolean);
procedure DBGridEh_DoPasteAction(DBGridEh: TCustomDBGridEh; ForWholeGrid:Boolean);
procedure DBGridEh_DoDeleteAction(DBGridEh: TCustomDBGridEh; ForWholeGrid:Boolean);
+ Added property EditActions: TDBGridEhEditActions.
TDBGridEhEditAction = (geaCutEh, geaCopyEh, geaPasteEh, geaDeleteEh, geaSelectAllEh);
TDBGridEhEditActions = set of TDBGridEhEditAction;
Specifies actions (inherited from TEditAction) that grid can update and execute.
+ Added some functions to support edit actions.
+ Added dghTraceColSizing value in TDBGridEhOption type (property OptionsEh).
dghTraceColSizing: Determines whether the column size changes before mouse button is released.
dghTraceColSizing is not supported under Delphi 3.
+ Procedures SaveColumnsLayout, RestoreColumnsLayout, SaveGridLayout, RestoreGridLayout overloaded to support TCustomIniFile in addition to TRegIniFile.
+ Added OnColWidthsChanged event. Occurs immediately after the column widths change.
+ Added Flat property. Makes the grid 3D borders more thinner, makes the grid rows more narrow, makes the fixed line gray.
+ Added support of the macro "&[Pages]" in PageColontitles.
&[Pages] substitutes the count of pages.
+ Added C++ Builder 5 support.
+ Added dghEnterAsTab values in TDBGridEhOption type (property OptionsEh).
dghEnterAsTab: Enter key behaves as Tab key in the grid.
+ Added allows to set focus to and resize of the frozen columns.
+ Added property FooterFont: TFont. Controls the attributes of the default footer font.
+ Added property FooterColor: TColor. Default background color of the footer.
+ Added property ToolTips: Boolean. Allows to show hint for text that don't fit in data cell.
+ Added property Footers: TColumnFootersEh. Allows to assign individual footer parameters for multiple footer rows.
+ Added property ToolTips: Boolean. Allows to show hint if text don't fit in title cell.
+ Added pghFitingByColWidths, pghOptimalColWidths values in TPrintDBGridEhOption type.
pghFitingByColWidths: allows to fit grid to page width by changing column widths (not scaling whole image).
pghOptimalColWidths: change column widths to fit text in the cells.
+ Added BeforeGridText: TStrings property to print/preview the rich text before grid.
+ Added AfterGridText: TStrings property to print/preview the rich text after grid.
+ Added procedure SetSubstitutes to set substitutes for BeforeGridText and AfterGridText.
+ Added possibility to Print/Preview of the selected area of TDBGridEh.
+ Added property TitleImages to show bitmap in titles instead of caption.
+ Added property AllowedOperations: TDBGridEhAllowedOperations;
TDBGridEhAllowedOperation = (alopInsertEh, alopUpdateEh, alopDeleteEh, alopAppendEh)
to forbid/allow insert, append new records; delete, update records.
+ Added cbsDropDown value in ButtonStyle property.
+ Added Hint property to show hint text above title for narrow columns.
+ Added ImageIndex property to show bitmap instead of caption text.
+ Mouse wheel support in TDBGridEh and TPreveiwBox
* Some bugfixes.
+ Added allows to create one title for several columns in frozen and nonfrozen zones simultaneously (in MultiTitle mode).
* In RowSelect mode change column widths don't move view to first column.
+ Added selecting a columns and rectangle areas
Added property Selection: TDBGridEhSelection;
TDBGridEhSelection contains next properties
TDBGridEhSelectionType = (gstNon, gstRecordBookmarks, gstRectangle, gstColumns, gstAll);
see EhLib.hlp and DEMO1 for detail.
* Clicks on left top cell in grid sets SelectionType = gstAll, but not selects all records.
+ When DragMode = dmAutomatic and dgMultiSelect is included in Options the grid enters in Dragging mode only when user pressed mouse on multiselected data area (not includes title, indicator and footer areas).
This version don't support print and preview of the selected area yet.
* Some bugfixes.
IMPORTANT FOR C++ BUILDER DEVELOPERS
ALL COMPLETIONS "EH" ARE REPLACED BY "Eh"
* Help file compiled under english localization settings
+ Added Delphi 5 support (Packages compiled under trial version of Delphi 5 (Build 4.32))
+ Added new component TPrintDBGridEh for printing and preview of TDBGridEh.
+ Added new component TPreviewBox for customizing preview form.
+ Added new object TPrinterPreview to direct printable stuff to the preview box.
* Highlighted frozen cells in rowselect mode
* Allows press title buttons and move columns by left mouse button simultaneously.
+ Added cbsUpDown value in ButtonStyle property.
+ Added Increment property. Works when ButtonStyle = cbsUpDown.
* Some bugfixes.
What's new in version 1.03:
New help file that can be inserted in Delphi help system.
Included support Borland C++ Builder versions 3 & 4.
+ Added dghAutoSortMarking, dghMultiSortMarking values in TDBGridEhOption type (property OptionsEh).
dghAutoSortMarking Automaticaly marking title by SortMarking images.
dghMultiSortMarking Allow sortmarking multiple columns. At runtime use Ctrl + Mouse combination for multisortmarking.
+ Added event OnSortMarkingChanged : TNotifyEvent;
+ Added procedure SaveGridLayout(ARegIni: TRegIniFile);
+ Added procedure RestoreGridLayout(ARegIni: TRegIniFile; RestoreParams:TDBGridEhRestoreParams);
+ Added procedure SaveGridLayoutIni(IniFileName: String; Section: String; DeleteSection: Boolean);
+ Added procedure RestoreGridLayoutIni(IniFileName: String; Section: String; RestoreParams:TDBGridEhRestoreParams);
+ Added property Checkboxes: Boolean. Determine need show checkboxes enstead of text. Checkboxes automativcaly true for boolean field. For non boolean fill first line of KeyList for checked checkboxes. Second line for nonchecked.
* Fixed some bugs.
What's new in version 1.02.
+ Added multyline editing.
+ Added edit of memo fields.
+ Added dghHighlightFocus, dghClearSelection, dghFitRowHeightToText values in TDBGridEhOption type (property OptionsEh).
dghHighlightFocus Highlight a focus cell
dghClearSelection Clear selected rows after selecting
dghFitRowHeightToText Fit row height to height of text lines
+ Added multiselect by the mouse.
+ Added trace a focus cell by the mouse.
* Fixed some bugs.
What's new in version 1.01.
+ Added HorzScrollBar and VertScrollBar properties to control the scrollbar in grid.
+ Added OptionsEh properties to specifies various display and behavioral properties of grid.
+ Added SaveColumnsLayoutIni and RestoreColumnsLayoutIni procedures to save and restore some grid parameters in/from ini file.
+ Added support to show drop down calendar for TDate and TDateTime fields.
+ Added DblClickNextVal property to set next value for some type of column on double mouse click.
+ Added KeyList property to show bitmaps from ImageList depending on field value and to show text from PickList.
+ Added ImageList property to show bitmaps depending of field value.
+ Added MaxWidth, MinWidth property to limit column width.
+ Added NotinKeyListIndex to show image for null field value.
+ Added support to work with no sequenced dataset as with sequenced.
* Fixed some bugs.