 |
This file contains Simple Query package history. Dec-01-2011 Version 4.9.0 -added: RAD Studio XE2 support. -fixed: Some problems with QueryPanel appearance. Apr-06-2011 Version 4.8.1 -added: OnElementCreate event in TKQueryPanel component; -added: aoHideRootRow option in Appearance.Options property of TKQueryPanel; -added: IsAggregate property of TDSField class; -added: aoHideRootRow property; -added: "Remove all" menu item in Result Fields Dialog; -fixed: Field list was not cleared in Result Fields Editor dialog; -fixed: Date/time format correction for Oracle syntax; -fixed: Wrong behaviour of Data Model Wizard under Delphi 2009 and higher; Nov-22-2010 Version 4.8.0 -added: RAD Studio XE support; -added: New property Appearance.LogOpStyle. It allows you to define the position of logical operator in condition; Dec-24-2009 Version 4.7.0 -added: Code Gear RAD Studio 2010 support; -added: SQLTopClause and SQLLimitClause properties in TKQueryPanel; -fixed: few small problems in the library and Data Model Editor; May-17-2009 Version 4.6.1 -fixed: Few small problems with library setup files; Mar-17-2009 Version 4.6.0 -added: Delphi 2009 support; -fixed: Access Violation problem on Result Fields Dialog close; Nov-20-2008 Version 4.4.1 -added: CaseInsensative property for Operators; -fixed: Wrong behaviour of QueryPanel when AutoSize=true; Dec-17-2007 Version 4.4.0 -added: Delphi 2007 support; -added: New function in TKQueryPanel component: AddSimpleCond - the replacement of ManualAddCond procedure; -fixed: Few minor bugs; Mar-02-2007 Version 4.3.5 -added: An ability to fill database structure at run time; -fixed: field ID was not set in AddFieldRef operation; -fixed: Wrong behaviour of TKResultFieldsPanel control when user change the sorting of some column; -fixed: Edit | Mask value editor did not allow to change mask format in Data Model Editor; Aug-08-2006 Version 4.3.4 -added: New property in TKDBStructure.SQLFormats: UseOuterKeyword. It allows to remove OUTER word from LEFT/RIGHT OUTER JOIN statements (useful for Access users); -added: "Auto" value editors now limit number of characters in edit boxes for string fields; -added: TkResultFieldsPanel now shows fields with expressions and aggregate functions as well as simple ones; -added: ToolTip is shown for long items in list value editor in case of using list box control; -fixed: problem in inputing float or currency constant values in query panel; -fixed: memory leak in LoadFromStrings methods of TKDBStructure class; -fixed: Root predicate was left disabled after deletion of single disabled condition; -fixed: setting TFilterCond.Value[] to empty string did not clear corresponding caption for list value editors; -fixed: AV error in TKResultFieldsPanel control on new result column addition; -fixed: Bug in ParseSQL operation - tables and field with quotes were not processed correctly; May-05-2006 Version 4.3.3 (revision 3) -added: Appearance.ButtonColor property; -added: Appearance.MainBtnCaption property; -changed: New design and behaviour of "Tables" page in Data Model Editor; -fixed: There was no way to set "False" value for QuoteDate and QuoteBool properties of TKDBStructure; -fixed: Some files were not included into installation; -fixed: Quoted tables were not quoted in WHERE clause (if its name is equal to its alias); -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: AV error when we load query with custom condition in query panel with psAndOr style; -fixed: Wrong behaviour of Data Model Editor under Windows XP; Jan-11-2006 Version 4.3.2 (revison 2) -fixed: Wrong SQL when TKQueryPanel.SQLSyntax is equal to ssSQL1 or ssOracle; -fixed: Minor problems during installation; Dec-29-2005 Version 4.3.1 -added: Borland Developer Studio 2006 support; -added: LoadLinksFromList method - fills Links property by information provided by TKDBInfo.GetLinkList method; -added: TADODbInfo component now retrieves the information about table relationships (foreign keys); -added: DMWizard processes information provided by TKDBInfo.GetLinkList method; -added: An ability to stop the process of links searching in DMWizard; -fixed: Wrong outer joins placement in some cases; Jun-30-2005 Version 4.3.0 -added: TKDBInfo component is added to palette. It can be used to get database information through several events; -added: new options for TKQueryPanel.Appearance.Options property: aoShowGroupRows. It allows to show group (bracket) rows even for AndOr style of panel; -added: an ability to add new rows after or inside current bracket; -fixed: wrong "open bracket" behaviour; -fixed: AV when some DB connection components were used; -fixed: Bug in "Edit Link " dialog: fields list did not appear for second table; Jun-16-2005 Version 4.2.5 -added: New event in TKDBInfo class (and all its descendants): OnGetSQLValues; -added: New sub-properties in SQLFortmats property: QuoteDate:boolean and QuoteBool:boolean; -added: New property TKQueryPanel.Appearance.Options.aoShowRowButtons; -added: a splitter between tables diagram and table parameters panels in Data Model Editor; -added: an ability to rearrange tables in the Data Model Editor; -added: new property in TFilterCond class: ValueRect[Index] : TRect. It returns bounds rectangle of any value element by its index; -changed: Edit Link dialog now shows table names with its aliases instead of table names only; -changed: Tables list are sorted in Data Model Editor dialog (Tables page); -fixed: wrong "is in list" operator parameters processing; -fixed: Problem with "is in list" operator and float values; -fixed: Bug in table joining - non optimal linking path was created for some queries; Dec-10-2004 Version 4.2.4 -added: True and False values are added into TKQueryPanel.Titles; -added: support for Delphi 2005; -changed: now Simple Query is separated on two kind of packages run-time and design-time; -changed: BDE support was excluded into separate package; -fixed: Problem with processing custom conditions in ParseSQL method; Oct-12-2004 Version 4.23 -added: An ability to turn on/off using LIST function in Result Fields Editor dialog through Options property in ShowResultFieldsDlg method; -added: New property SubQueryAppearance. It allows to define appearance settings of the sub-query panel; -added: New property SubQueryFont. It allows to define font of the sub-query panel; -added: "Connect" button in Data Model Editor dialog. It appears only if corresponding event (OnConnectClick) is defined in TKDBStructure component; -changed: An ability to control hints for sub query in query panel (SQL or query description); -fixed: Problem in ParseSQL function: it could not process GROUP BY clause properly; -fixed: Problem in ParseSQL function: it could not process query with 'between' operator in first condition; -fixed: Problem in ParseSQL function: it did not recognize "" (not equal) operator correctly; -fixed: Problem in ParseSQL function: it could not process IN operator correctly; -fixed: 'Null' operator now operates with two arguments (field and one value); -fixed: Problem with right-click on "Sorting grid" in Result Fields Editor dialog; -fixed: Problem with parameter caption if corresponding field is changed; -fixed: Problem with value caption when it represents a sub query; Jun-18-2004 Version 4.22 -added: DMOptions.StoreDBInfo property; -added: new option for TKQueryPanel.ShowResultFieldsDlg method rfdDisableExpressions; -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: 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-17-2004 Version 4.21 -added: An ability to build queries under several databases; -added: New properties in TKDBStructure component: DMOptions, SQLFormats.FullTableName; -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: an ability to use LIST aggregate function in Result Fields Editor; -added: an ability to add tables and links manually, without connection to database; -fixed: Drop Down list does not have enough space to show all characters in the list items; -fixed: "Index out of bounds" error during link addition in Data Model Editor; -fixed: "Access violation" when calling Data Model Editor from TKDatasetStructure component; Feb-20-2004 Version 4.15 -added: an ability to specify value type (string, integer or float) for "Edit" value editor in Data Model dialog; -fixed: user was not able to input negative integer and read values when "Auto" value editor is used. -fixed: wrong behaviour of TKDBStructure.RetriveDataModelInfo method (field groups were not added); -fixed: paramter names are cleared after loading of the query; -fixed: an exception during saving the query with sub-queries under date/time fields; Jan-15-2004 Version 4.14 -added: an ability to user an expression in the left part of linking conditions; -added: an ability to use Data Model Editor dialog at design-time for TKDatasetStructure component; -changed: TKResultField now scroll down automatically when the new row exceeds the bottom of the control after insertion; -fixed: Wrong behaviour when changing the kind of "EDIT" value editor in Data Model dialog; -fixed: Wrong structure saving at design time when TKDBStructure is linked to TKQueryPanel; -fixed: Memory leak in TKDBStructure component; -fixed: Wrong description of custom conditions with two values in query panel; Jan-02-2004 Version 4.13 -added: an ability to define other the "false" and "true" values for boolean fields; -fixed: wrong behaviour of TKQueryPanel.LoadCurBaseQuery method if query base is empty; -fixed: Wrong behaviour of ParseSQL function in case if incoming SQL expression contains 'or' or 'and' string values inside; Dec-17-2003 Version 4.12 -added: OnLoadModel and OnSaveModel events in TKDBStructure component; -changed: new DoXXXX protected virtual methods in TKQueryBase which corresponds to events provided by that class; -changed: changing WorkDir in TKQueryFileBase while it is active cause query list refresh; -changed: ProcessDataValue method in TKQueryPanel component became protected and virtual; -fixed: several small problems in TKQueryBase and TKQueryFileBase components; -fixed: fields with ftFixedChar or ftWideString types did not contain any operator by default; -fixed: wrong link conditions definition in Edit Link dialog; Dec-05-2003 Version 4.11 -added: an ablity to use expressions in the right side of linking conditions; -changed: internal component TFlatCheckBox was renamed to TKFlatCheckBox to avoid type name duplication; -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: 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; -fixed: "Edit Link" dialog did not allow to use the same field two times in linking conditions ; Oct-10-2003 Version 4.10 -added: HAVING clause processing. Now all conditions with virtual fields with aggregate functions in expression will be placed into HAVING clause of result SQL statement; -changed: changing the DisplayName property for parameter (TSQLParam object) now reflects to its name shown in query panel; -changed: OnValueDblClick event now is raised for parameters too; -fixed: problem when binary operator (is between) is changed to unary operator (e.g. "is equal to"); -fixed: problems during Data Model Editor resizing/moving; -fixed: parameters type was not changed when new field was assigned to a condition; -fixed: captions of values were erased during operator changing; -fixed: wrong behaviour of Data Model Editor on empty data model; Jul-14-2003 Version 4.08 -added: new "sqFilter" option in SQLOptions property in TKQueryPanel. It makes Simple Query suppress table name for queries which include only one table in result statement; -added: "Version" property in TKQueryPanel - returns current version of the package; -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 4.07 -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 in Data Model Editor when "Tables" panel was scrolled; -fixed: problems in GROUP BY clause generation; Jul-01-2003 Version 4.06 - fixed: wrong filter expression (contains table alias) when using TKDatasetStructure+TKFilterProvider; - fixed: AV after deleting the last condition in Data Model Editor; Jun-25-2003 Version 4.05 - added: new component: TKQueryList - similar to TKQueryCombo (created by Mike Tuttle); - fixed: wrong behaviour in "Tables" page in Data Model Editor when it is used with TKDatasetStructure component; - fixed: "Unrecognized field" error for result fields which were added at design time; - fixed: AV while structure loading when some table was not found; - fixed: wrong syntax of SQL statements with IN operator; - fixed: aliase were not created for aggregate fields; - changed: Captions generation rules for aggregate fields; Jun-17-2003 Version 4.02 - Fixed: Table properties were not saved in Data Model Editor dialog; - Fixed: Wrong behaviour of the grid for "List" value editor in Data Model Editor dialog (only one row could be added); - Added: "Edit Link" button in Data Model Editor Dialog; - Added: FilterSyntax property in TKDatasetStructure; - Changed: WildCardSymbol property is removed from TKDatasetStructure component (substituted by FilterSyntax); - Changed: now Data Model Editor dialog can work without DatabaseInfo specified; Jun-16-2003 Version 4.01 - Fixed: AV on closing the form with TKQueryPanel when fields list is opened; - Fixed: AV after value setting when a custom condtion exists in the query; - Fixed: OnChange event did not occur after rows moving; - Fixed: Some problems in help and installation; Jun-13-2003 Version 4.00 - Added: New design of Structure Editor dialog - now it is called Data Model Editor; - Added: Custom conditions: now developer can specify list of custom conditions which can be used during query building; - Added: Now current row in TKQueryPanel 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; - Changed: TFilterCond class now divided on two: TSimpleCond and TCustomCond; - Added: New AddRowColor property in TKQueryPanel.Appearance. - Added: New LinkTypes property in TKQueryPanel.Appearance. - Added: New DefaultLinkType property in TKQueryPanel - specifies the default link type for all brackets in query except the main one; - Added: Processing lookup fields in TKDatasetStructure and TKFilterProvider components; - 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; - Added: new property in TKDbInfo class: Connected; - Changed: Talbes property in TKDBInfo class is changed to GetTableNames procedure; - Added: new method in TKDbInfo class: GetLinksList; - Added: new event in TKDBInfo class: OnRequestLinks; - Added: New method of TKDBStructure - RetriveDatabaseInfo provides an ability to retrive information about database structure automatically (for some kind of databases) or semi-automatically; - Added: New property in TKDatasetStructure: WildCardSymbol. Allows to change wildcard symbol used in filter statements ("*" by default, must be "%" for DBISAM and some other databases); - Changed: TFilterCond properties Value1, Value2 changed to Values[Index], Value1IsParam and Value2IsParam to ValueIsParam[Index]; - Fixed: Some bugs in TKQueryBase component and its descendants; - Fixed: Wrong behaviour in processing DefOperators property in TKDBStructure component; - Fixed: Problem in using virtual fields in GROUP BY operation; Dec-05-2002 Version 3.41 1. Added: Two default operators: "is not in list" and "is not between". 2. Changed: Boolean fields now are not applied for >, <, >=,