 |
This file contains Active Query package history. Sep-28-2010 Version 3.7.0 -added: New default operator "is not null"; -added: New method: RemoveStructOperatorByID(); -fixed: Tooltip is shown now for multi-select drop-down list as well; May-13-2009 Version 3.6.0 -added: New property in ResultFieldsPanelX: OptShowCompoundExpr; -fixed: Few small problems in Result Fields dialog and library controls; Feb-04-2009 Version 3.5.0 -added: New method in QueryPanelX: FillStructureByRecordsetEx; -added: New method in QueryPanelX: BuildFilters; -added: New method in QueryPanelX: GetFilterByTableName; Nov-19-2008 Version 3.4.5 -fixed: Wrong behaviour of Result Fields Dialog in IE 7; -fixed: "Unrecognized field" message in ResultFieldPanelX control for calculated fields; -fixed: Wrong result of ParseSQL method for SQL statements with NOT operator; -fixed: Few small problems in sample projects; 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 >, <, >=,