Absolute Database: History of changes
=====================================

- version 5.18 (06/12/2008)

  Bugs fixed:
  1. Problem with default values and MEMO fields is solved
  2. Problem with Autoinc fields and multithread applications is solved
  3. Problem with internal progress dialog and restructuring long tables is solved
  4. Problem with wrong conversion of date to string and back in SQL is solved

- version 5.17 (02/14/2008)

  Bugs fixed:
  1. Problem with ORDER BY, Join and fields with the same names is solved
  2. Problem with ORDER BY and UNION is solved
  3. Help improved
  4. Problem with Delphi 2007 integration is solved

- version 5.16 (12/13/2007)

  Bugs fixed:
  1. Problem with NULL values and <> operator is solved

- version 5.15 (11/26/2007)

  Bugs fixed:
  1. Problem with duplicate database error is solved
  2. Problem with default CURRENT_TIMESTAMP value is solved
  3. Problem with Field Not Found error with some SQL quoeries is solved
  4. Problem with TRIM function and <> operator is solved
  5. Problem with exporting to SQL and table names with dashes is solved
  6. Problem with restructuring tables and Largeint type is solved
  7. zlib version has been updated 


- version 5.14 (09/06/2007)

  Bugs fixed:
  1. Probem with executing some SQL queries in multithread application is solved
  2. Problem with importing some Paradox tables is solved
  3. Problem with dates comparison in SQL is solved


- version 5.13 (04/04/2007)

  New features:
  1. Delphi 2007 support
  
  Bugs fixed:
  1. Several problems with additional TAbsSession componen are solved
  2. Problem with importing Oracle BLOB fields is now solved
  3. Problem with VARBYTES type and ALTER TABLE command is solved
  4. Problem with default field values like "C:\Folder" is now solved

- version 5.12 (01/20/2007)

  Bugs fixed:
  1. Problem UNION ALL query and blob fields is solved
  2. Problem with 2 TAbsDatabase components within the same application and read-only
     mode is solved


- version 5.11 (11/29/2006)

  Bugs fixed:
  1. Memory leak in TAbsQuery.Free when query result contained AutoInc fields
  2. Wrong order of fields in JOIN queries

- version 5.10 (10/26/2006)

  Bugs fixed:
  1. Compatibility problem with TMSSecurity components is solved
  2. Requires section of Absolute DB design time package for BDS2006 is fixed
  3. Problem with icons in Delphi 2005 is fixed
  4. Problem with default value NOW is solved


- version 5.09 (09/21/2006)

  Bugs fixed:
  1. Bug with default values is fixed
  2. Bug with comparing CURRENCY and INTEGER types is fixed
  3. Access Violation error when repairing some databases is fixed
  4. Some C++ Builder demos were not compile, fixed
  


- version 5.08 (08/24/2006)

  Bugs fixed:
  1. LastAutoInc function now works immediately after opening a table and doesn't require to add a record first (only in single user mode)
  2. Problem with NOT LIKE and empty fields is fixed
  3. Errorneous queries INSERT ... VALUE didn't generate a error, fixed
  4. Problems wirth LIKE and LOWER, UPPER functions and index are solved
  5. Problem with converting Integer field values to Cardinal in queries INSERT .. SELECT is solved


- version 5.07 (07/19/2006)

  Bugs fixed:
  1. Problem with LIKE and primary index is fixed
  2. Problem with LIKE and LOWER function is fixed
  3. Pakages for Delphi 9 and 10 are marked as design-time and run-time
  4. Problem with BYTES data type is solved
  5. Bug with too long record lock time is fixed
  6. Bug with invalid casting from DATETIME to DOUBLE is fixed
  7. Problem with negative default field values is solved
  8. Bug with Locate and  Buffer Size Exceeded error is fixed

- version 5.06 (06/01/2006)

  Bugs fixed:
  1. Problem with SQL quieries with conditions like UPPER(Expr1) = UPPER(Expr2) is fixed
  2. Problem with x64 Edition of Windows XP is solved
  3. Bug with rising wrong exeption whe wrong field names are used is fixed


- version 5.05 (04/27/2006)

  New features added:
  1. $DEFINE directive to exclude dialogs.pas unit is added

  Bugs fixed:
  1. Memory leak bug with Query.Open\Close for specific queries is fixed.
  2. Bug with ExportToSQL are fixed
  3. Database path can be specified in TableName parameter
  4. Problem with LIKE and Upper\Lower functions is fixed
  5. BatchMove bug when index is violated is fixed
  6. Bug with CopyTable and AccessVioaltion error is fixed
  7. Help on creating tables is updated
  8. Bug with RestructureTable on filtered tables is fixed
  9. Bug with AccessViolation error in DBManager when opening some tables isfixed
  10. Bug with Print Table Structure dialog in DBManager is fixed

- version 5.04 (01/20/2006)

  New features added:
  1. Speed of SQL "SELECT Count(*) FROM ..." is increased.
  2. Absolute DB now tries to reopen network database file in case of a short-time network disconnection.
  3. QueryMaker is added to Absolute DBManager, special thanks to Nick I.Timchenko for his great contribution.  
  4.  SQL datetime functions are now supported in a default field value.
  5.  SQL ROUND function syntax is extended to support the specification of precision and rounding mode.

  Bugs fixed:
  1. Bug with LargeInt fields in BatchMove is fixed.
  2. Bug with not released locks with two database components is fixed.
  3. Error with FindKey buffer bounds with calculated fields is fixed.
  4. Parameters in ORDER BY are now supported.
  5. Problem with CopyTable when some field objects are not created is solved.
  6. Bug with WideString fields in Delphi 2006 is fixed.
  7. Opening encrypted database by the 2nd database component with wrong password is disabled now.
  8. Bug with cast(current_date-datetime_field as integer) is fixed.
  9. TABSAdvIndexDefs.Update method is added.
  10. TABSAdvIndexDefs.Update method is added.
  11. "Integer Overflow" bug on more than 2 billions calls of  FreeMem is fixed.


- version 5.03 (12/15/2005)

  New features added:
  1. Speed of search condition " Field LIKE 'str%' " processing is increased if an index on Field is available.

  Bugs fixed:
  1. Bug with AV after accessing BLOB field in OnFilterRecord event is fixed.
  2. Bug with UPDATE table from another database is fixed.
  3. Error in ToString with Roman date parameter is fixed.
  4. Problem with create and drop a memory table in a SQL script is solved.
  5. ExportToSQLOptions now could be stored in DFM file.
  6. Search conditions like (BooleanField) are now supported.


- version 5.02 (11/10/2005)

  Bugs fixed:
  1. Bug with MEMORY option with CREATE INDEX statement is fixed.
  2. Null params for SQL queries are now supported.
  3. Bug with disconnecting at design-time from deleted database file is fixed.
  4. Syntax parsing error with subquery in UPDATE statement is fixed.
  5. Bug with distinct subquery is fixed.


- version 5.01 (10/14/2005)

  New features added:
  1. Uncorrelated subqueries speed is increased.
  2. ESCAPE option support is added for LIKE operator.
  3. Performance of some SQL queries with TOP option is improved.

  Bugs fixed:
  1. Bug with loPartialKey option used by Locate is fixed.
  2. Creation of index on BLOB fields is disabled.
  3. Error on distinct selecting into memory table with RequestLive=True is fixed.
  4. Repair procedure is enhanced to repair table data even if internal system data of a table is lost.
  5. Bug with indexed positioning of record after refresh on deleted record is fixed.
  6. Bug with ignoring SilentMode property in some SQL queries is fixed.
  7. Password option now can be used with TRUNCATE TABLE SQL command when external encrypted database is referenced.
  8. Problem with Exception "frmWait.DesignSize: Property does not exist" is solved.
  9. Bug with blank fields in multiple unions query is fixed.
  10. TDataSetNotifyEvent declaration is corrected to conform with the declaration in DB.pas.
  11. Bug with opening table in exclusive and non-exclusive mode at the same time is fixed.
  12. Duplicated fields in a SELECT query are now supported.
  13. Error on specific brackets combination in SQL query is fixed.
  14. RecordSize property value is corrected.
  15. Bug with null BLOB param in SQL query is fixed.


- version 5.00 (09/01/2005)

  New features added:
  1. Database performance is significantly improved in a multi-user mode 
     with a database file located on a remote server.
  2. SQL Engine: Single-table queries with DISTINCT or ORDER BY now run 
     much faster with RequestLive=False.
  3. SQL Engine: Speed of read-only queries with BLOB fields is increased a lot.
  4. SQL Engine: New syntax for UPDATE statement is supported to speed up UPDATE with subqueries.
  5. Locate speed with the loPartialKey option is increased if an appropriate index exists.
  6. DBManager is improved. Special thanks to Rik Halfmouw.

  Bugs fixed:
  1. Bug with not commited pages of temporary index is fixed.
  2. Problem with update of Graphic fields via TClientDataset is solved.
  3. Support of an external database in the SQL INSERT syntax is added.
  4. Table name is added to the error messages of database repair.
  5. Required fields error messages are corrected.
  6. Bug with using Absolute DB in DLL under Win2000 is fixed.
  7. Problem with indexing WideMemo fields is solved.
  8. Bug on record editing in master-detail is fixed.
  9. Bug on record editing in master-detail is fixed.
  10. Bug with locks if the Edit is called outside transaction, but the Post is inside is fixed.


- version 4.90 (07/20/2005)

  New features added:
  1. TField.OldValue property is supported now.
  2. Speed of a non-correlated subqueries in a SELECT fields list is improved

  Bugs fixed:
  1. Table, Field and Index names in SQL export are quoted automatically now.
          TABSExportToSqlOptions.QuotedNames property is removed.
  2. Bug with update of index with MaxIndexedSize lower than field length is fixed.
  3. Bug with exporting to SQL timestamp values is fixed.
  4. Error messag