  |
|
|
|
|
|
|
This file contains Simple Query package history.
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 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 >, <, >=, <= and "between" operators.
3. Fixed: Wrong behaviour during assigning new value to TKQueryPanel.Appearance.BoolColor property.
4. Fixed: Constatnt/Parameter popup menu appear even when aoAllowParams options is set to 'False';
Nov-19-2002 Version 3.40
1. Added: InitialSEPath property in TKDBStructure component - the initial path for Load and Save operations in Structure Editor dialog;
2. Added: Ability to use table hints (NOLOCK, ROWLOCK) in table definition;
3. Added: TKQueryPanel now allows to set up images for field groups and fields in drop-down popup menu;
4. Added: OnSEHelpClick event in TKDBStructure component;
5. Added: OnRFEHelpClick event in TKQueryPanel component;
6. Added: "Add default operators" button in Structure Editor;
7. Adedd: AddDefOperators method in TKDBStructure components;
8. Fixed: Installation did not add the packages into Delphi 7 IDE automatically;
9. Fixed: DateTimePicker control was not placed correctly;
10. Fixed: Bug in processing DateTimePicker input if ShortDateFormat has 2 digit for year.
11. Fixed: Bug in generation SQL statements with sub-queries (using aliases for fields in SELECT part of sub-query);
Oct-01-2002 Version 3.30
1. Added: Delphi 7 support;
2. Added: aoAllowParams option in TKQueryPanel.Appearance.Options property;
3. Added: ability to use another than "equal to" (=) operators in joins;
4. Fixed: Wrong behavior in Right-to-left BiDiMode;
5. Fixed: Bug in processing "QuoteAliases" option for the result fields which are inserted more than one time;
Sep-17-2002 Version 3.21
1. Fixed: "Edit Link" button in Structure Editor did not show the selected link;
2. Changed: "Auto" value editor is used in TKDatasetStructure by default instead of "Edit";
3. Fixed: Wrong behaviour of TKDatasetStructure components in connection to Apollo database;
3. Changed: SQLFormats and DefOperators properties became published in TKDataSetStructure component;
4. Added: DatasetName property in TKDataSetStructure;
5. Added: ExOperators property in TKDBStructure and TKDatasetStructure components;
6. Added: FilterStr property in TKFilterProvider component;
8. Fixed: An ability to build sub-query with date/time fields;
Aug-05-2002 Version 3.20
1. Added: Titles editor now works for TKResultFieldsPanel too;
2. Added: ClearRows method in TKQueryPanel component;
3. Added: Appearance.Options property in TKResultFieldsPanel component. The following options now available: aoFlatButtons, aoRoundButtons, aoPopupField, aoShowGroupName;
4. Fixed: The bug in processing LEFT and RIGHT outer joins when the tables are inserted into the query in different order than they comes in link description;
5. Added: Apperance.BoolOpColor property - specifies the color of boolean operator in AndOr style;
6. Added: Titles for SUM, COUNT, etc. operators in Result Fields Dialog.
7. Added: support for ftTimeStamp field type (new in Delphi 6);
Jun-27-2002 Version 3.11
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 TKQueryPanel - any textual data now can be saved together with query;
4. Fixed: Bug in editing of "List" value editor;
5. Fixed: Bug in DropDownPopup component (the popup menu did not appear after first click);
May-31-2002 Version 3.10
1. Added: Add, Delete, Edit speed buttons in Structure Editor dialog;
2. Added: OnChange event in TKDBStructure component;
3. Fixed: Bug in parsing compound table names;
4. Fixed: OnConditionChange event was not executed when the user clicks on "and/or" label;
5. Fixed: Bug in parsing "is in list" operator with string values;
6. Fixed: AV during deleting last row in bracket;
Apr-03-2002 Version 3.02
1. Fixed: AV exception during form loading;
2. Fixed: Problem with parsing SQL statements which contains date and time fields;
3. Fixed: Wrong text returned by TKQueryPanel.QueryText property;
Apr-01-2002 Version 3.01
1. Fixed: Wrong data in last field added into TKResultFieldsPanel;
2. Fixed: Order of fields is not change in TKResultFieldsPanel;
3. Fixed: Sorting order of fields is not change in TKResultFieldsPanel;
4. Fixed: MaxPopupItemCount didn't work in TKQueryPanel;
Mar-25-2002 Version 3.0
1. Added: New control: TResultFieldsPanel;
2. Added: BiDi mode support;
3. Added: Two sytles of query panel component: with or without group headers;
4. Changed: Options properties now divided on two parts: appearance options and SQL options.
5. Added: "Select Distinct" option in Sub-Query dialog;
6. Added: Parameters can be used in SQL value editor;
7. Added: An ability to set the parameters instead of constant values in conditions;
8. Added: DefOperators property in TKDBStructure - list of default operator which are added into any new created structure;
9. Changed: BDE independence - No default BDE support, now you should use special TBDEDBInfo component to connect to database using BDE.
10: Fixed: bug in processing virtual fields (tables included into virtual field's expression were not added to the result SQL statement);
11. Fixed: Bug in ParseSQL method concerned processing operators with non-string values (e.g. "Cost is equal to 1000");
12. Fixed: Parsing SQL expression with sub-queries
Nov-22-2001 Version 2.96
1. Fixed: Bugs with query generating when all conditions are disabled;
2. Added: OnCoditionChange event now executed when user disable/enable a condition;
3. Added: Enabled/Disabled status for condition now is saved into query file;
4. Fixed: Bug in ParseSQL method concerned to processing names in quotes;
5. Changed: Design of the add/delete buttons now is totally flat in "FlatButtons" mode;
Sep-10-2001 Version 2.95
1. Added: Ability to disable any conditon in query without deleting it;
2. Added: "Auto Upper Case" and "Auto Lower Case" options for value editors (in Structure Editor dialogs);
3. Fixed: Several bugs in ParseSQL method;
Jul-03-2001 Version 2.92
1. Added: property MaxPopItemCount in TKQueryPanel;
2. Added: SQLFormats.QuoteSymbol1 and SQLFormats.QuoteSymbol2 properties in TKDBStrcuture component. Default values are ". Set it to [ ] for Access database.
3. Fixed: 'Enter' and 'Esc' keys reaction in Structure Editor;
Jun-24-2001 Version 2.91
1. Ability to cancel changes in Structure Editor;
2. Help buttons in Structure Editor and Result Fields Editor dialogs.
3. New properties in TKQueryPanel: HelpFileName - name of the help file and RFEHelpContext - context ID for help topic which describes Result Fields Editor dialog;
4. New properties in TKDBStructure: HelpFileName - name of the help file and SEHelpContext - context ID for help topic which describes Structure Editor dialog;
Jun-06-2001 Version 2.9
1. An ability to create query with sub-queries;
2. An ability to select several values from the list for "is in list" like operators (CheckListBox as value editor);
3. BeforeOpen,AfterOpen,BeforeClose,AfterClose events in TKQueryBase component;
4. Interface improvments in Result Field Editor dialog;
Apr-03-2001 Version 2.81
1. New OnConditionChange event;
2. TKQueryPanle.OnChange now executes on result field changing;
3. Value editor now accepts only that kind of data which is used in corresponding field in the condition. For example: if type of the field in some condition is integer then the value editor accepts only digits.
Feb-06-2001 Version 2.8
1. New ParseSQL method in TKQueryPanel create query conditions in panel by SQL SELECT statement;
2. New events in TKQueryPanel component: BeforeBuildFilter and AfterBuildFilter;
3. Parameter list changed in OnValueDblClick event; Now it has "var Value" parameter to change the value of edit field;
4. New options: poBracketCondition, poBracketJoins - specify if each condition and each JOIN clause must be encloused into brackets;
5. New button: Clear in the Structure Editor dialog;
6. Bug fixed: "Access Violation" exception during reading database structure with long table names (with spaces in names);
Oct-27-2000 Version 2.7
1. New ability: user can add a condition by one mouse click (see new poShowAddRow option in the TKQueryPanel component);
2. One TDropDownLabel control was broken to 4 new controls: TDropDownEdit, TDropDownMaskeEdit, TDropDownPopup, TDropDownListBox. New class hierarchy allows to add new embeded controls for different value types more easily and quickly;
3. New feature: kind of value editor "edit" type. There are four kinds: simple, mask, date, time for corresponded field types;
4. New embeded DateTimePicker control (TDropDownDateTime) for editing date and time values;
5. Now all conditions in result SQL are enclosed into brackets (some database engines require it).
6. Error in list values quoting was checked;
7. Several small bugs were fixed;
Sep-13-2000 Version 2.62
1. New exception handling structure: all exception are derived from ESimpleQueryError and has special error code (can be read from ErrCode property);
2. Several changes in ActivateQuery method of TKFilterProvider component. Now it throw exception if the filter expression has wrong syntax and return expression to previous value;
3. Property RootFieldsFirst added to DBStructure which allows to show root fields before all groups in Result Fields editor and QueryPanel;
4. Fixed range check error in KQuerPnl.pas;
5. Fixed bug with operators which use one value several times like "LEFT( @f, LEN('@1') ) = '@1'" ;
6. Fixed bug with saving and loading constant values in complicate operators like YearIsInList where the value type differs from field type;
7. Fixed bug dealing with MaskEdit: All literals in input string were not cleared;
8. Fixed sorting popup menu bug in Result fields Editor.
Aug-10-2000 Version 2.61
1. Fields and groups in QueryPanel now drop down in the order specified in the Structure Editor;
2. Bug with moving field's operations in the Structure Editor fixed;
3. Bug with operation deleting in the Structure Editor fixed;
4. Bug with remaining fields when group is deleted fixed;
5. Bug with deleting BDE alternative component from the form when selecting the DatabaseInfo for KDBStructure fixed;
6. Button New Result Field in Result Fields Editor is enabled now;
7. Bug with not keeping field order in the root group in Structure Editor
Jul-27-2000 Version 2.6
1. New option "QuoteAliases" was added in TKQueryPanel component;
2. Bug with group deleting in Structure Editor fixed;
3. Bug with popup menu shortcuts in Structure Editor fixed;
4. Bugs with empty Query Panel fixed;
5. Bug in Structure Editor loading fixed;
6. Changing fields order ability in Result Fields Editor added;
7. Bug with last field deleting in Structure Editor fixed.
Jul-15-2000 Version 2.5
1. Loading from titles error fixed;
2. Loading structure and loading RFE time reduced;
3. CondField property added to TDSField;
4. Bugs in fields tree in the Structure Editor fixed;
5. Bug with selecting Value Editor Type in the Structure Editor fixed;
6. Help file updated.
Jun-23-2000 Version 2.5b
1. Result Fields editor redesigned;
2. Structure editor redesigned;
3. Titles editor redesigned;
4. Fixed: linking multiple-word fields bug;
5. Fixed: not storing "Quote table names" option;
6. poOracleJoins option added to Query Panel for Oracle joins style;
7. Fixed: KQueryBase bug with creating new queries (professional edition).
Apr-16-2000 Version 2.1
1. TKQueryPanel now saves display names (values captions) in conditions;
2. Property State was added to TKQueryPanel. New states: stIdle, stBuilding, stLoading, stSaving;
3. Repaint distortion while using custom editors fixed;
4. Original field name now displays in the Structure editor on Fields tab;
5. Bug with old database structures in sqReadSLSectionValues method fixed;
6. Link editor bug fixed;
7. Bug with Quoted fields fixed.
Mar-15-2000 Version 2.03
1. Bug with multiple links between tables fixed;
2. Bug with result fields saving and loading fixed;
3. Bug with focus losing after ESC key press in query panel fixed.
Mar-10-2000 Version 2.02
1. Bugs with old structure and queries incompatibility fixed
Now old database structures and queries can be used without any problem;
2. QueryPanel bug after query deletion fixed.
Mar-07-2000 Version 2.01
1. Bugs with loading and saving structure fixed;
2. Help file updated;
3. Sample program for standard edition components added into distribution package.
Feb-20-2000 Version 2.0
1. Pro version released with 4 new components;
2. Keyboard input feature added;
3. Ability to create and work with user defined "virtual" fields;
4. Customizable QueryPanel colors;
5. Several minor updated, changes and bug fixes.
Nov-11-1999 Version 1.72
1. ADO support component;
2. Support for ftWideString and ftLargeInt field types;
3. Ability to quote fields in links.
Nov-02-1999 Version 1.71
1. Bug with quoted field storing fixed;
2. Bug with complicated field storing fixed;
3. Displaying group name feature in Result Field editor and Query panel was added.
4. Ability to add DISTINCT into generated SQL statement;
5. Help updated.
Oct-06-1999 Version 1.7
1. Titles editor added for suitable package localization;
2. QuotedTypes property added to TKDBInfo to define the set of TFieldType which must be quoted in SQL statement;
3. Simple Query automatically changes quotes to double quotes to avoid errors in SQL syntax;
4. Uninstall support improved for more clear package removing;
5. Generated SQL queries now work more effective because of MainTable property now doesn't needed in the the most cases.
Aug-28-1999 Version 1.6
1. Quotes in the field names.
2. New field value edtitor "SQL". First colum - values, second - items.
3. Ability to work with field groups in Result Fields Editor.
4. Ability to set edit mask for field values.
Bugs fixed:
1. "Access violation" during saving structure after deleting a field.
2. Error in saving and loading quries with complex result fields.
3. Error when not existing MainTable is defined.
Jul-22-1999 Version 1.5
1. Now one table can be joined into query more than one time. Now when you setup links between tables you operates with table aliases;
2. Fields grouping: now you can to unite fiels into groups which will be shown as sub-menus during query building.
May-12-1999 Version 1.3
1. BDE alternatives support !
2. New component TKDBInfo was added. TKDBInfo is an ancestor
for components which can be written by developer
for BDE alternatives support (with source code).
3. ODBCExpress 5 support as BDE alternatives support example (with source code)
Apr-7-1999. Version 1.23
1. Links between tables was improved. Now you can create links built
on several fields.
2. Bugs fixed.
Mar-31-1999. Version 1.22
1. DBStructure has SQLFormats property now. It allows you to
use your own date and time formats for SQL queries.
2. New QueryPanel options was added. Now you can choose the
appearance of drop down lists between popup menu and list box.
Feb-18-1999. Version 1.21.
1. Drag & drop changing fields and tables order in Structure Editor.
2. Default main table can be set in Structure Editor.
3. New inner joins style support (ANSI SQL 92).
4. Spaces are allowed in result fields names.
5. Several small enhancements.
Feb-03-1999. Version 1.2.
1. Ternary operations support (like BETWEEN).
2. The ability to add new operations.
3. Install/uninstall support.
4. Left, right and full outer joins support.
5. Options property was added to KQueryPanel. It allows you to change panel appearance.
6. When adding fields, automatically add all operators that would apply to the field type.
7. Some interface enhancements.
Jan-05-1999. Version 1.1.
1. User interface updated: rounded flat buttons and popup-menu instead list boxes (by users wishes).
2. Now TKQueryPanel is inherited from TScrollBox - so the scroll bar will appear when the conditions list does not find enough room on panel.
3. OnCustomEdit event parameters list was changed. Now only Value is passed to event handler. To change Caption use new event OnChangeValue.
4. New event was added OnChangeValue. It allows to set the specific Caption value. To learn how to use this event see the demo project and the online help.
Dec-22-1998. Version 1.05.
1. The query storage format was changed. SimpleQuery 1.05 can't read the query
files (.qry) previously saved by version 1.0. If you already use old qry-files
in your project(s) please contact us and we will convert these queries.
2. Property MainTable was moved to the public section. Now it has TDSTable type.
3. New published property MainTableName was added. You can use it instead
of MainTable property to assign the main table at design time.
4. Now the result fields list can be saved into dfm-file, so you can use the
property editor to assign the result fields list at design time.
Dec-12-1998. Version 1.0 release.
 |
|
(c) Copyright 1998-2008 Korzh.com. All rights reserved.
Powered by Beacon system.
This page last modified: 13-Aug-2007
|
|
Home/Products