Welcome, Guest!
Log in
home : Easy Query : EasyQuery.NET : WinForms edition changes history
20-Aug-2008 Version 2.2.1
 -added: Data property in ValueRequestEventArgs class;
 -changed: new column row is activated automatically in QueryColumnsPanel;
 -fixed: ValueRequest and other events were not processed in sub query dialog;

01-Aug-2008 Version 2.2.0
 -added: UseDbName property in SqlFormats class;
 -added: Visual Studio 2008 support;
 -changed: Now column caption by default contains entity + attribute name;
 -fixed: Few small problems in library controls;


09-Jul-2008 Version 2.1.0
 -added: new option in QueryPanel: Appearance.ShowRowNum;
 -changed: New visual style for Data Model Editor (XP themes support);
 -fixed: Several small problems in DME and library components;

23-May-2008 Version 2.0.0
 -added: New Data Model Editor - fully rewritten on .NET
 -added: New UI for sub-query definition;
 -added: An ability to select entity attribute in the right side of condition (through Ctrl+Click);
 -added: An ability to define macro values (e.g. );
 -added: An ability to translate default operators;
 -added: New operators for date/time values (before, after, etc.);
 -added: An ability to organize operators into several predefined groups;
 -added: New behaviour of [click here to add new ...] label in QueryPanel or QueryColumnsPanel;
 -added: Maximum length of edit box in conditions is set according to the size of corresponding attribute;
 -added: New value kind: Attribute;
 -added: An ability to use {exprN.table} or {exprN.field} macros in operator expressions;
 -added: An ability to fill the list of operators for some attribute with defaults;
 -changed: Global code refactoring have been done;
 -fixed: Several small problems have been fixed;


12-Feb-2008 Version 1.11.0
 -added: An ability to set user-defined model name in DataModel class;
 -added: CreateValueElement event in QueryPanel;
 -added: An option to turn on/off aggregate columns menu in QueryColumnsPanel;
 -fixed: Wrong behaviour when JustSorting=true in QueryColumnsPanel;

05-Dec-2007 Version 1.10.2
 -added: An ability to set the text for empty elements (like [enter value]);
 -changed: Input box is shown now for "starts with" or "contains" operators in any case;
 -fixed: Problem with comma and double-quote symbols in list values.

05-Nov-2007 Version 1.10.1
 -fixed: Wrong processing of list values;
 -fixed: SQL keywords (like "FROM") were not taken in quotes;

25-Oct-2007 Version 1.10.0
 -added: An ability to set the color of attribute, operator or expression label;
 -added: LazyJoins property in Query.Options;
 -added: New option "Use in sorting" which permit or forbid sorting for an attribute;
 -fixed: Problem with single quotes in sub-queries;
 -fixed: SortColumnsPanel items are scrambled;

10-Jul-2007 Version 1.9.2
 -fixed: Unhandled exception on ListRowElement when user clicks on [Select value];
 -fixed: An ability to use space separated list for numeric values in EditRowElement;

25-Jun-2007 Version 1.9.1
 -fixed: Problem with "is in list" operator;

22-Jun-2007 Version 1.9.0
 -added: An ability to mark any aggregate column as DISTINCT;
 -added: An ability to mark any operator as "Case insensative";
 -added: "Use in ..." filter in Data Model Editor (DME);
 -added: An ability to add stored procedures and Oracle views in DME;
 -added: CustomValue event in QueryPanel for "Custom" value editor;
 -added: An ability to save User Data for entities;
 -added: More suitable editor for numeric values in QueryPanel control;
 -added: An ablity to hide Caption in QueryColumnsPanel (Appearance.AllowEditCaption property);
 -fixed: "Type of expression" property of operators did not work correctly;
 -fixed: Problems with Crtl+ keystrokes;
 -fixed: Quotes were wrongly used in sub-queries;
 -fixed: Error when user disables the only condition in query;

15-Mar-2007 Version 1.7.0
 -added: Database options for ADO Gate in Data Model Editor: now user can indicate if he/she wants to see Views and Linked Tables in the list of all available tables;
 -added: New overloaded LoadFromFile and SaveToFile functions in Query class: now they allows to load/save only columns or only conditions;
 -changed: Row element classes registration mechanism: now it is similar to registration of Expression descendants;
 -fixed: The exception which is generated if transparent color is used in QueryPanel rows;
 -fixed: The error that occured in DM Editor and DM Wizard under Windows Vista;
 -fixed: Few small bugs in DM Editor;
 
 

24-Jan-2007 Version 1.6.2
 -added: NullAttribute property in DataModel - gets default entity attribute object for "unrecognized" attributes;
 -added: Quote property to Table class;
 -added: An ability to use sub-queries in Query Panel (now only as plain SQL statements);
 -changed: More informative error messages;
 -fixed: Problem with virtual attributes;
 -fixed: Null reference exception on some queries;
 -fixed: Some minor issues in Data Model Editor and Data Model Wizard programs;


01-Nov-2006 Version 1.6.1
 -added: Query.GetConditionsText method - allows to get human readable representation of query conditions;
 -added: SqlFormats.AlphaAlias property - allows to control the format of column alias in result SQL statement;
 -added: Database schemas support in Data Model Editor;
 -added: New property in DataModel.Table: SchemaName;
 -added: SqlFormats.UseSchema property;
 -added: SqlFormats.DefaultSchemaName property;
 -added: "Quote" property for entity attributes;
 -changed: Drawing performance has beed improved for XListBox and its descendants (QueryPanel, QueryColumnsPanel);
 -fixed: LinkType was not saved for root query predicate;
 -fixed: Wrong behaviour on adding condition in multi level query;
 -fixed: Wrong checkboxes placement for predicate rows;
 -fixed: QueryPanel painting problems;
 -fixed: Some minor problems in Data Model Wizard application;
 -fixed: problem with horizonal scroll bar in XListBox control;
 -fixed: An exception during moving rows in QueryColumnsPanel;
 -fixed: Some minor issues in QueryPanel control;


30-Sep-2006 Version 1.6.0
 -added: VB.NET demo project;
 -added: New method of DataModel class FillByDataTable which allows to fill model by DataTable object;
 -added: An ability to fix (make read-only) some condition elements - Appearance.EditMode property;
 -added: XAppearance.ReadOnlyColor property - specify the color of read-only elements;
 -added: New method of DataModel class which allows to add default list of operators - AddDefaultOperators;
 -added: New Appearance.ShowCheckboxes property in XListBox class;
 -added: DbsPort and QryPort utilites which allow to convert old .qry and .dbs files (used in Simple/Active Query) to new formats;
 -added: DefExprType property in DataModel.Operator class;
 -changed: ColumnsChanged event now has more specific type ColumnsChangedEventHandler instead of common EventHandler type;
 -fixed: Text in condition row was cut off in "Large fonts" mode. Now it is possible to set Appearance.TuneElementSizes to true to avoid that;
 -fixed: NotStartsWith and NotContains operators were not processed correctly;
 -fixed: Several minor bugs in Data Model Editor;
 -fixed: Wrong drop-down listbox position in case of placing query panel on MDI form;
 -fixed: Wrong processing of the default type property for operators in Data Model Editor and query panel;
 -fixed: LinkType was not saved for root query predicate;

11-Jul-2006 Version 1.5.1
 -added: StoreModelPath  property in Query class;
 -added: QueryName and QueryDescription properties in Query class;
 -added: Description property in DataModel class;
 -added: FilePath property in DataModel class;
 -added: DataModel.DatabaseParameters class that represents different options of database linked with datat model;
 -added: DbParams property in DataModel class;
 -added: StoreDbParams property in DataModel class; 
 -added: New Data Model Editor dialog: supports several levels of entities, new format of operator expressions, new design of tables/links pane and allows to edit connection settings;
 -added: Data Model Wizard program that allows to create new data models easily;
 -added: an ability to show fully qualified entity attribute name (with entity name prefix). AttrElementFormat properties in QueryPanel.Appearance and QueryColumnsPanel.Appearance;
 -added: Attribute tooltip in QueryPanel and QueryColumnsPanel controls;
 -added: GetSql method of Query.Result object. Allows to get SQL statement with custom SELECT and ORDER BY clauses;
 -added: An ability to specify "custom list" value editor in Data Model Editor. This value editor does not contain list of items but has a name and can be filled at run-time;
 -added: ListRequest event - allows to fill items at run-time for "custom list" value editors;
 -added: An ability to specify color of addition row in QueryPanel and QueryColumnsPanel controls;
 -changed: the way Data Model object generates entity attribute IDs ("table.field" pattern is used now instead of numbers);
 -changed: class names are changed (Entity - EntityAttr, EntityGroup - Entity) to unify data model object with their internal representation;
 -changed: QueryColumnsPanel was separated on two controls: QueryColumnsPanel and SortColumnsPanel;
 -changed: QueryPanel and QueryColumnsPanel use less memory and GUI resources now;
 -fixed: rendering problems in QueryPanel and QueryColumnsPanel objects;
 -fixed: Single quote in constant values used in conditions was not replaced by double quotes in result SQL statement that caused SQL execution error;
 -fixed: several minor bugs;
 
 

03-Mar-2006 Version 1.4.2
-------------------------
 -added: Appearance.ShowEntityGroupName property. It allows to show entity group names in conditions. For example: "Customers.Company Address";
 -changed: QueryPanel and QueryColumnsPanel flickering on repainting was reduced;
 -fixed: Query.ConditionsChanged event was raised several times when query is loaded from file;
 -fixed: Problem with saving list values into query files;

14-Feb-2006 Version 1.4.1
-------------------------
 -added: support for .NET framework 2.0 and VS 2005;
 -added: Query.ConditionsChanged event now is fired when some part of a particular condition (e.g. operator) is changed; 
 -added: New properties in Query.SqlFormats: TrueValue and FalseValue. They allow to specify text that will be used in result SQL expressions for boolean values "True" and "False";
 -fixed: Problem with "is in list" operator and string values (they were not enclosed into quotes);
 -fixed: Wrong behaviour of QueryColumnsPanel control in "JustSorting" state;

30-Dec-2005 Version 1.4.0
-------------------------
 -added: AggrFunc and AggrFuncExpr classes - represents aggregate functions;
 -added: An ability to specify different result column types in QueryColumnsPanel control;
 -added: New result column type: Aggregate Function;
 -added: Aggregate columns processing in Query component, automatical creation of GROUP BY clause;
 -added: QueryPanel and QueryColumnsPanel controls now are ready for localization through resource files;
 -added: Table hints support: now you can indicate table hint in Data Model Editor and it will be used in genereated SQL;
 -added: SaveToString and LoadFromString methods of Query class;
 -added: several additional constructors for ConstExpr class (they simplify ConstExpr object creation through code);
 -added: ValidateValue event in QueryPanel class;
 -fixed: BorderStyle property did not work correctly in QueryPanel or QueryColumnsPanel controls;
 -fixed: Wrong behaviour on columns sorting changes;


03-Dec-2005 Version 1.3.2
-------------------------
 -added: UseColumnAliases property in SqlFormats class;
 -added: An ability to assign user data with any entity in Data Model Editor;
 -added: UserData property value for entities now is saved and loaded to/from data model file;
 -fixed: Error on trying to access SQL value editor when SqlExecute event of QueryPanel control is not handled;
 -fixed: Wrong behaviour of QueryColumnsPanel in case we add a column into "sorting list" first;
 -fixed: Wrong behaviour when Deactive/Activate methods are used in QueryPanel control;


28-Nov-2005 Version 1.3.1
-------------------------
 -changed: QueryPanel now shows [select value] for empty values when LIST or SQL value editor is used;
 -changed: Now DataModel automatically propose type of element (MENU or LISTBOX) depending on number of values for LIST value editor;
 -fixed: DateTimePicker control (which is used for DATETIME value editor) closed when user tries to change the month on  calendar window;
 -fixed: Problems with ListBox placement on form when LIST value editor is used;
 -fixed: Error when query panel tries to create element with use LIST value editor;


22-Nov-2005 Version 1.3.0
-------------------------
 -added: Row elements classes structure was re-designed. New types of ListRowElement - ListBox and CheckListBox;
 -added: Query panel now automatically use CheckListBox control to edit values in conditions with "is in list" operator;
 -added: DateTime format in Formats property of Query component;
 -added: EOL property in Formats property of Query component - allows to specify end-of-line symbol(s) for generated SQL statements;
 -added: SelectDistinct option in Query.Options;
 -added: UserData property in Entity class - allows to associate any custom data with entity object;
 -fixed: date/time constant values processing and their incorrect formatting in generated SQL statements; 


01-Nov-2005 Version 1.2.0
-------------------------
 -added: New value editor for date/time values;
 -changed: ShowBorder property was removed from QueryPanel.Appearance. Now BorderStyle property is used;
 -changed: The following properties were moved from main panel control to Appearance property: ElementSpacing, LevelSpacing, LeftMargin, AdjustChildLevel;
 -fixed: Necessary tables were not added into SQL when the query does not contain conditions (only result columns);
 -fixed: Wrong panel border and buttons painting during panel scrolling;
 -fixed: Incorrect element alignment in query panel and columns panel;
 -fixed: the default value was not assigned for boolean and date/time values;

25-Oct-2005 Version 1.1.0 
-------------------------
 -added: Root predicate row in QueryPanel control. It allows to change the way how first level conditions are linked;
 -added: OrderByStyle property in SqlFormats class. Allows to define the way how fields will be represented in ORDER BY clause;
 -changed: Row buttons became rounded;
 -changed: Logic and visual parts of EasyQuery were separated to different assemblies (it is necessary for future ASP.NET support);

29-Sep-2005 Version 1.0.1 
-------------------------
 -fixed: Query.Formats property serialization;
 -fixed: Wrong number of brackets in the FROM clause of generated SQL;
 -fixed: Incorrect processing of tables which has one or more spaces in their names;

28-Sep-2005 Version 1.0.0 
-------------------------
 -added: JustSorting property saving/loading to/from XML;
 -added: ORDER BY clause generation; 
 -added: ColumnsAppearance and SortAppearance properties in QueryColumnsPanel control;
 -added: An ability to specify 
 -fixed: Several small problems in SQL statement generation;


12-Sep-2005 Version 0.30.0 
--------------------------
Beta 3 release
 -added: An ability to define value editors for entities in data model;
 -added: EditValueEditor class;
 -added: ListValueEditor  class;
 -added: SqlListValueEditor  class;
 -added: SqlListRowElement control class that supports SQLLIST value editor;
 -added: List of available types for operators - AppliedTypes property;
 -added: An ability to save/load value editors and their parameters into data model XML file;
 -added: SqlExecute event in QueryPanel control;
 -added: Appearance property in XListBox and QueryPanel;
 -added: Design-time support for some properties;
 -added: Query.Column and Query.ColumnList classes;
 -added: Columns saving and loading to/from XML;
 -added: New control: ResultColumnsPanel - allows to add result columns and specify their sorting;
 -added: "Trivial" sample application now shows the result of built query;
 -fixed: Some bugs in Data Model Editor;


23-Aug-2005 Version 0.12.0
--------------------------
Beta 2 release:
 -added: Help files;
 -changed: Classes structure improvments;

18-Aug-2005 Version 0.11.0 
--------------------------
Beta 1 release:
 -added: Data model editor as stand-alone application;
 -changed: Classes structure improvments;

10-Aug-2005 Version 0.10.0 
--------------------------
Second alpha release. 
 -added: An ablity to group rows;
 -added: Buttons near to each row;
 -added: Query saving/loading;


18-Jul-2005 Version 0.9.0
-------------------------
First alpha release.


(c) Copyright 1998-2008 Korzh.com. All rights reserved.
Powered by Beacon system.
This page last modified: 13-Aug-2007