  |
|
|
|
|
|
|
This file contains Active Query package history.
Mar-07-2007 Version 3.4.0
-added: ToolTip is shown for long items in list value editor in case of using list box control;
-added: FillStructureByRecordset method. It allows to fill model (entity attributes mainly) by some record set;
-added: OptFilterSyntax property. If it is True the result SQL statement will have the sytax more suitable for filter expressions (for example field name will not be prefixed with table names);
-added: RunDMWizard method in QueryPanelX control: allows to run Data Model Wizard to make modifications in data model;
-fixed: Wrong behaviour of ResultPanelX control when user change the sorting of some column;
-fixed: AV error in ResultFieldsPanelX control on new result column addition;
-fixed: Bug in ParseSQL operation - tables and field with quotes were not processed correctly;
-fixed: Edit | Mask value editor did not allow to change mask format in Data Model Editor;
Jun-12-2006 Version 3.3.2
-added: property Enabled in FilterRowX object;
-added: ResultFieldsPanelX control now shows the fields with expressions and/or aggregate functions;
-changed: New design and behaviour of "Tables" page in Data Model Editor;
-fixed: Quoted tables were not quoted in WHERE clause (if its name is equal to its alias);
-fixed: Active Query did not include necessary brackets in FROM clause with joins;
-fixed: Bug with "is in list" operator: it could not process values with spaces correctly. Example:
Word1, Word2 Word3 was recognized as Word1, Word2, Word3;
-fixed: Data Model Editor did not refresh alias in Active Table combo box after it was changed by user;
-fixed: Wrong Data Model Wizard behaviour in "full screen" mode;
-fixed: Wrong behaviour of "click to add a condition" link. If current row is inside some group it added new condition outside this group;
-fixed: Data Model Editor and Data Model Wizard did not show tables and fields correctly for Oracle databases;
Mar-20-2006 Version 3.3.1
-added: SchemaID property in QueryPanelX control;
-added: OptAsciiAliases property - turn on/off an ability to use non ASCII symbols in result field names and aliases;
-fixed: The dropdown list went outside of the visible screen if it contained some long item;
-fixed: Sub-query panel did not use the same options as defined for main query panel. Now it does;
-fixed: Incorrent definition of rfdoCountDistinctFunc constant;
Jun-05-2005 Version 3.3.0
-added: An ability to turn on/off using LIST function in Result Fields Editor dialog through Options property in ShowResultFieldsDlg method (rfdoListFunc option);
-added: An ability to turn on/off using COUNT DISTINCT function in Result Fields Editor dialog through Options property in ShowResultFieldsDlg method (rfdoCountDistinctFunc option);
-added: An ability to turn on/off any of link types (All, Any, None or Not All) through new properties UseLinkAll, UseLinkAny, UseLinkNone, UseLinkNotAll;
-added: New OnCustomValueEx event. It contains new ValueIndex parameter;
-added: New OnGetConnection event. Allows to use your own connection object inside Active Query object;
-added: Connect function in QueryPanelX control;
-added: LastConnectError property in QueryPanelX control;
-added: New property OptShowRowButtons - allows to turn on/off buttons in query panel;
-added: New property OptShowBracketRows - allows to show bracket rows even for AndOr style of panel;
-added: an ability to add new rows after or inside current bracket;
-fixed: Problem with "special" symbols in result field aliases in generated SQL statement;
-fixed: Problem with "is in list" operator and float values;
-fixed: Bug in table joining - non optimal linking path was created for some queries;
-fixed: AV error when OptPopupValue is false under VB.NET;
-fixed: Long value list was covered by task bar;
-fixed: wrong "open bracket" behaviour;
Jun-18-2004 Version 3.2.1
-added: OptStoreDBInfo property - allows to prevent saving database connection info with data model descriptor (.dbs) file;
-added: now QueryPanelX.ShowResultFieldsDlg method can take 3 options: rfdoDisableSorting, rfdoOnlySorting, rfdoDisableExpressions;
-added: an ability to add fields to structure without connection to database;
-added: Edit Link dialog appears when user makes double-click on some link in Table Links list;
-changed: an ability to modify field type and size in Data Model Editor;
-changed: Data Model Editor now used DB owner name (if defined) when tryes to get list of field for some table;
-fixed: Data Model Wizard controls did not fit necessary size in case of using "large fonts";
-fixed: problem with decimal separator on several locales (such as Greek);
-fixed: Full Screen mode in Data Model Editor did not work correctly;
-fixed: Wrong field group name after some field was dragged from one group to another;
Apr-27-2004 Version 3.2.0
-added: An ability to build queries under several databases;
-added: "Full screen" mode of "tables" page in Data Model editor;
-added: special Data Model Wizard helps to create new data models "on the fly";
-added: New properties in OptMultiDB, FullTableNameFormat;
-added: OptStoreDBInfo property - controls storing DBSpecInfo section into the structure file;
-added: an ability to use LIST aggregate function in Result Fields Editor;
-added: an ability to add tables and links to structure manually, without connection to database;
-fixed: Drop Down list does not have enough space to show all characters in the list items;
Feb-27-2004 Version 3.11
-added: FalseValue and TrueValue properties. They allows to set another then "False" and "True" values for boolean fields (e.g. 0 and 1);
-added: an ability to specify value type (string, integer or float) for "Edit" value editor in Data Model dialog;
-fixed: Wrong behaviour of ParseSQL function in case if incoming SQL expression contains 'or' or 'and' string values inside;
-fixed: fields with ftFixedChar or ftWideString types did not contain any operator by default;
-fixed: user was not able to input negative integer and read values when "Auto" value editor is used.
-fixed: wrong link conditions definition in Edit Link dialog;
-fixed: an exception during saving the query with sub-queries under date/time fields;
Nov-22-2003 Version 3.10
-added: HAVING clause processing. Now if you define a virtual field with aggregate function and use it in some condition - Active Query will place this condition into HAVING clause in result SQL statement;
-added: new property Opt3DStyle - specifies control appearance (3D or not);
-added: new property OptDMEOpenSaveButtons - allows to hide Open and Save buttons in Data Model Editor;
-added: "Order Fields in Group" menu item in Data Model Editor (Fields page) - allows to sort fields in current group alphabetically;
-added: CustomData property in FilterConditionX object;
-added: New properties QuoteSymbol1 and QuoteSymbol2 allows to change quote symbols for different types of databases;
-added: Ability to get data type for field in condition (DataType property in TDSFieldX object);
-added: an ablity to use expressions in the right side of linking conditions;
-changed: Changing operator from "in list" to "equals" now removes superfluous values in value list (leave only first one);
-changed: SQL expression field size in Data Model dialog is increased;
-fixed: problem when binary operator (is between) is changed to unary operator (e.g. "is equal to");
-fixed: wrong behaviour during calling Data Model Editor or Result Fields Editor when control is used on the web page;
-fixed: wrong behaviour during control resizing;
-fixed: problem with "List" value kind for custom conditions;
-fixed: problem with control licensing when the user has no administrator rights;
-fixed: Data Model Editor did not show field list for the tables with spaces in name;
-fixed: wrong TO_DATE function format when Oracle SQL syntax is used;
-fixed: ListBox control shown for List value editor was wrongly clipped if it does not fit to query panel;
-fixed: In Data Model editor new table was added always with the corresponding group and fields (even if "Automatically add fields" checkbox was turned off);
-fixed: On some data modeles an "Acccess violation" error was raised when first added row was bracket;
Jul-15-2003 Version 3.02
-fixed: AV on closing Data Model Editor if current table list is empty;
-fixed: fields marked as "quoted" were not quoted if there is only one table in query;
Jul-10-2003 Version 3.01
-added: Links list for current table in Data Model Editor dialog;
-fixed: wrong behaviour of Add Tables operation Data Model Editor if "AutoAddFields" option is turned on;
-fixed: an error during ParseSQL executing on the SQL statements with one table;
-fixed: problems with links addition for new data model in Data Model Editor;
-fixed: problems with links selection in Data Model Editor;
-fixed: wrong links position when "Tables" panel was scrolled;
-fixed: problems in GROUP BY clause;
Jul-08-2003 Version 3.00
- Added: Data Model Editor;
- Added: Custom Conditions - now the developer can specify list of custom conditions which can be used during query building;
- Added: Now current row in Query Panel can be moved and change its level through Ctrl+ key combinations;
- Added: Right click on "addition row" equals to pressing on main button (at the root of the conditions list);
- Added: Pressing Alt+Ins now shows the popup menu for current row;
- Added: Automatically insert TO_DATE function for date/time fields in Oracle databases;
- Added: Automatically propose 'False' and 'True' values for boolean fields in conditions;
-Changed: Captions generation rules for agregate fields;
- Fixed: Problem with List value editor;
- Fixed: Problem with query panel representation for larger than default font sizes;
- Fixed: Problem with scrolling on web-pages;
- Fixed: Wrong SQL while using parameters for non-string fields;
- Fixed: Problem with Help button in Structure Editor dialog;
- Fixed: Aliases were not generated for aggregate result fields;
- Fixed: Wrong names of aggregate fields in ORDER BY clause;
- Fixed: Data Model Editor dialog appeared as separate window (not owned by the main applicatio) which caused some problems during switching between applications (through Alt+TAB key combination or any other way);
Nov-20-2002 Version 2.3
1. Added: InitialSEPath property in QueryPanelX component - the initial path for Load and Save operations in Structure Editor dialog;
2. Added: ability to use another than "equal to" (=) operators in joins;
3. Added: "Add default operators" button in Structure Editor;
4. Added: Ability to use table hints (NOLOCK, ROWLOCK) in table definition;
5. Added: Two default operators: "is not in list" and "is not between".
6. Added: Now QueryPanelX and ResultFieldsX controls can be used in .NET applications;
7. Added: GroupName edit field for group nodes in Structure Editor;
8. Changed: Boolean fields now are not applied for >, <, >=, <= and "between" operators.
9. Fixed: DateTimePicker control was not placed correctly;
10. Fixed: "Edit Link" button in Structure Editor did not show the selected link;
11. Fixed: An ability to build sub-query with date/time fields;
12. Fixed: Bug in generation SQL statements with sub-queries (using aliases for fields in SELECT part of sub-query);
13. Fixed: Wrong behaviour during assigning new value to OptBoolColor property.
Oct-05-2002 Version 2.2
1. Added: OptAllowParam property in QueryPanelX control - allows to turn on/off the ability to use parameters instead of constants in the value field;
2. Added: OptSortByNames property in QueryPanelX control - specify what kind of ORDER BY clause will be used in result SQL statements (ORDER BY 1,2,.. or ORDER BY Field1, Field2,...);
Sep-21-2002 Version 2.1
1. Added: Titles editor for ResultFieldsPanelX control (available through right-click on the control);
2. Added: New properties in ResultFieldsPanelX control: OptPopupField, OptShowGroupName, FieldColor, SortColor;
3. Added: New methods in ResFieldListX: InsertFieldSQL, AddFieldSQL - allow to add result fields by SQL expression;
4. Changed: Titles editor in QueryPanelX was move into separate dialog instead of property page.
5. Added: BoolOpColor property - specifies the color of boolean operator in And/Or style of query panel;
6. Added: LoadStructureFromFile method in ResultFieldsPanelX control;
7. Changed: Structure loading now works more faster in QueryPanelX and ResultFieldPanelX controls;
Jul-03-2002 Version 2.01
1. Added: Add/delete group speed buttoms in Structure Editor dialog;
2. Added: "Use in conditions"/"Use in result" options for field in Structure Editor;
3. Added: New property UserData in QueryPanelX control - any textual data now can be saved together with query;
4. Fixed: Bug in editing of "List" value editor;
5. Fixed: Bug in query panel: popup menu (with the list of available fields or operators) did not appear after first click;
6. Fixed: Bug in query panel: the panel was not refreshed when some options (e.g. OptRoundButtons) is changed;
Jun-10-2002 Version 2.0
1. Added: New control: ResultFieldsPanelX;
2. Added: BiDi mode support;
3. Added: Two sytles of query panel component: with or without group headers;
4. Added: "Select Distinct" option in Sub-Query dialog;
5. Added: Parameters can be used in SQL value editor;
6. Added: An ability to set the parameters instead of constant values in conditions;
7. Changed: Speed buttons for most useful operations in Structure Editor dialog;
8. Fixed: bug in processing virtual fields (tables included into virtual field's expression were not added to the result SQL statement);
9. Fixed: Bug in ParseSQL method concerned processing operators with non-string values (e.g. "Cost is equal to 1000");
10. Fixed: Bug in ParseSQL method concerned processing "is in list" operators;
11. Fixed: OnCustomValue event is not called when operator is "in sub query";
Oct-22-2001 Version 1.43
Added: Added: Ability to disable any conditon in query without deleting it (property OptShowCheckBoxes);
Added: OnConditionChange event;
Added: Enable/Disable menu item when user presses condition button;
Sep-08-2001 Version 1.42
1. Added: New property CurrentCondition in QueryPanelX control;
2. Added: "Auto Upper Case" and "Auto Lower Case" options for value editors (in Structure Editor dialogs);
3. Added: New property SQLJoinClause - returns join conditions for SQL statements where old style of table joins were used (in WHERE clause instead of INNER/OUTER JOIN in FROM clause);
4. Added: New sample /demos/web - an example of using Active Query on web-page;
5. Fixed: Several bugs in ParseSQL operation;
Jul-27-2001 Version 1.41
1. Added: QuoteBool property - indicate if boolean(logical) fields must be quoted in SQL statement. Set it to 'False' for Access databases;
2. Added: OptOracleJoins property - allows to generate Oracle outer joins;
3. Added: Long popup list of values now automatically breaks to several columns if it does not fit into screen height;
4. Fixed: 'Enter' and 'Esc' keys processing in Structure Editor;
5. Fixed: Shortcuts now work on Field page in Structure Editor.
Jun-23-2001 Version 1.4
1. New feature: sub-queries;
2. Added: OptBracketJoins option;
3. Added: OptSortListData option;
4. Added: Ability to select several values from the list of available for "is in list" like operators;
5. Added: New properties - HelpFileName, SEHelpContext, RFEHelpContext;
6. Changed: Structure Editor now can be accessed by right-clicking the control and choosing "Structure Editor..." menu item.
Apr-08-2001 Version 1.3
1. New interfaces for accessing to result field list: ResFieldListX (the whole list) and ResultFieldX (one item of this list);
2. New button: "Clear" in the Structure Editor dialog;
3. Bug fixed: "Access Violation" exception during reading database structure with long table names (with spaces in names);
4. New ParseSQL method in QueryPanelX object;
5. New properties ResultFields and StructFields in QueryPanelX object;
Oct-26-2000 Version 1.2
1. New interfaces to access conditions list and all parts of each condition:
FilterRowX, FilterCondition, FilterBracket, DSFieldX, DSOperatorX;
2. New ability: user can add a condition by one mouse click;
3. Embeded DateTimePicker control for editing date and time values;
4. Now all conditions in result SQL are enclosed into brackets (some database engines require it).
5. Sevral small bugs were fixed;
Sep-4-2000 Version 1.1
1. Option "Show Root Fields First" added to Structure Editor;
2. Fixed:
- bug with operators which use one value several times like "LEFT( @f, LEN('@1') ) = '@1'" ;
- bug with saving and loading constant values in complicate operators like YearIsInList where the value type differs from field type;
- bug dealing with MaskEdit: All literals in input string were not cleared.
- bug with moving field's operations in Structure Editor;
- bug with operation deleting in the Structure Editor;
- bug with remaining fields when group is deleted;
- bug with not keeping field order in the root group in Structure Editor
- bug with group deleting in Structure Editor;
- bugs with empty query panel fixed;
- bug with last field deleting in Structure Editor.
Jul-22-2000 Version 1.0
 |
|
(c) Copyright 1998-2008 Korzh.com. All rights reserved.
Powered by Beacon system.
This page last modified: 13-Aug-2007
|
|
Home/Products