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

- version 7.93 (10/07/2021)

  New features added:
  1. Support for Delphi and C++ Builder 11 Alexandria 32 and 64-bit is added. 
  2. DBManager utility is adopted to compile in Delphi 10.4 Sydney. 

  Bugs fixed:
  1. Run SQL script export data with WideMemo field "Cannot cast from 'BLOB' to 'STRING' - Native error: 30052" error is fixed.


- version 7.92 (06/19/2020)

  New features added:
  1. Support for Delphi and C++ Builder 10.4 Sydney 32 and 64-bit is added. 


- version 7.91 (01/21/2019)

  New features added:
  1. Support for Delphi and C++ Builder 10.3 Rio 32 and 64-bit is added. 


- version 7.90 (05/17/2017)

  New features added:
  1. Support for Delphi and C++ Builder 10.2 Tokyo 32 and 64-bit is added. 


- version 7.80 (05/14/2016)

  New features added:
  1. Support for Delphi and C++ Builder 10.1 Berlin 32 and 64-bit is added. 

  Bugs fixed:
  1. Win64 compilation issue in some Delphi versions is fixed. 


- version 7.70 (10/05/2015)

  New features added:
  1. Support for Delphi and C++ Builder XE10 32 and 64-bit is added. 


- version 7.61 (05/18/2015)

  Bugs fixed:
  1. Master-detail bug with Delphi XE8 is fixed. 


- version 7.60 (04/27/2015)

  New features added:
  1. Support for Delphi and C++ Builder XE8 32 and 64-bit is added. 


- version 7.50 (09/29/2014)

  New features added:
  1. Support for Delphi and C++ Builder XE7 32 and 64-bit is added. 


- version 7.40 (05/19/2014)

  New features added:
  1. Support for Delphi and C++ Builder XE6 32 and 64-bit is added. 


- version 7.30 (10/08/2013)

  New features added:
  1. Support for Delphi and C++ Builder XE5 32 and 64-bit is added. 

  
- version 7.20 (05/05/2013)

  New features added:
  1. Support for Delphi / C++ Builder XE4 is added. 

  Bugs fixed:
  1. Error with DataEvent in 64-bit mode is fixed. 
  2. Error with frmWait.DesignSize exception in D4 and D5 is fixed. 
  
  
- version 7.12 (02/18/2013)

  Bugs fixed:
  1. Error with intrenal Zlib decompression is fixed. 

  
- version 7.11 (02/05/2013)

  New features added:
  1. Support for C++ Builder XE3 64-bit is added. 


  Bugs fixed:
  1. Error with updates via ClientDataset is fixed. 
  2. Error with TOSTGRING(field, 'DY') SQL function is fixed.
  3. C++ Builder XE3 comilation error is fixed. 
  4. Error with BLOBs under 64-bit is fixed.


 - version 7.10 (09/30/2012)

  New features added:
  1. Support for Delphi / C++ Builder XE3 is added. 

  
- version 7.05 (05/25/2012)

  Bugs fixed:
  1. Error 20189 still appeared with some machine and IDE configurations is fixed. 


- version 7.02 (05/21/2012)

  Bugs fixed:
  1. Error 20189 with opening table in design-time in XE2 is fixed. 
  2. "Not implemented" error with TABSTable.OnFilterRecord event is fixed. 


- version 7.01 (05/17/2012)

  Bugs fixed:
  1. Error with opening encrypted database is fixed. 
  2. DBManager font problem with non-English characters is fixed. 


- version 7.00 (03/28/2012)

  New features added:
  1. Support for 64-bit in Delphi / C++ Builder XE2 is added. 

  Bugs fixed:
  1. Repair database function is improved. 
  2. Error with export binary data from SQL (MimeToBin) is fixed. 


- version 6.20 (11/18/2011)

  New features added:
  1. Support for Delphi / C++ Builder XE2 (32-bit) is added. 

  Bugs fixed:
  1. Bug with custom Database.OnNeedRepair event is fixed.


- version 6.09 (06/21/2011)

  Bugs fixed:
  1. Bug with exception while using ClientDataset is fixed.
  2. Bug with mxArrays not found is fixed.
  3. Interface issue with DBManager transparent panels is fixed.


- version 6.08 (06/15/2011)

  New features added:
  1. TABSTable.IsRecordLocked function is added to check if record is being edited by another user. 
  2. ABSMain.StartDisconnected variable is added. 
     You can use it to disable design-time db connections 
     on application start, to avoid errors with 
     non-existing database file path.
  3. DBManager works faster with databases with thousands of tables and now it uses fast memory manager FastMM.

  Bugs fixed:
  1. Bug with exception on some JOIN commands is fixed.
  2. Bug with lost current position after filtering is fixed.
  3. Bug of default memory manager in D4-D7 is fixed.

- version 6.07 (09/09/2010)

  New features added:
  Delphi XE and C++ Builder XE support.

  Bugs fixed:
  1. Bug with not correct assign of Unicode string to Memo, fmtMemo fields in D2009 and higher is fixed.
  2. Bug with invalid code page in Execute SQL script function of DBManager is fixed.
  3. Bug with using wrong fields in ALTER TABLE SQL command in D2009 and higher is fixed.


- version 6.06 (06/09/2010)

  New features added:
  ABSVariant.DefaultLocaleToCompareWideString variable is added. It could be used to specify locale used for Unicode strings comparison.

  Bugs fixed:
  1. Bug with impossibility to close database on removable drive after disconnecting the removable drive is fixed.
  2. Bug with invalid multi-thread/multi-user synchronization of database pages causing "Cannot delete EAM or PFS page" error is fixed.
  3. The [ABSDlgWait] dialog Position property is changed to poScreenCenter instead of poDesktopCenter, it allows the "repairing database" dialog to be shown correctly on dual-screen PCs.
  4. Bug with converting WideMemo<->Memo on RestructureTable in Delphi 2009, 2010 is fixed.


- version 6.05 (09/18/2009)

  New features added:
  Delphi 2010 and C++ Builder 2010 support.


- version 6.04 (06/30/2009)

  Bugs fixed:
  1. Bug with selecting records in DBGrid having the same value of active index is fixed.


- version 6.03 (06/29/2009)

  New features added:
  1. Indexing Unicode string fields in Delphi/CB 2009 is changed to be locale independent. 
     If you have indexes on Unicode strings and use Delphi 2009, please do compact or repair database to update existing Unicode string indexes.
  2. DBGrid record selection speed was significantly improved.
  3. Zlib is updated to 1.2.3 version.

  Bugs fixed:
  1. Bug with not raising constraint violation exception in TABSTable.InsertRecord is fixed.
  2. Database repair is improved.
  3. Bug with extending database file to the size larger than 20Gb is fixed.
  4. Bug with updating record via TCLientDataset was fixed.
  5. Memory allocation problem in Vista with large databases is fixed.
  6. Bug with conditions like Upper(field1)=Upper(Field2) is fixed.


- version 6.02 (01/20/2009)

  Bugs fixed:
  1. Bug with DISTINCT in subquery was fixed.
  2. Bug with Locate modified record in ordered query in multi-user mode (Native error: 10432) is fixed.
  3. Bug with getting RecNo of record modified by another user in indexed and filtered table is fixed.
  4. Wrong detection of upper/lower case of string constants in SQL expressions is fixed.
  5. Bug in Lower and Upper SQL functions with 8-bit ascii strings is fixed.
  6. Bug with WideMemo field in D2009 is fixed.
  7. Validation of correct reading database file pages is improved.
  8. Added firing password request when encrypted database is being compacted, repaired or having DB params changes.


- version 6.01 (12/03/2008)

  Bugs fixed:
  1. Problem with Delphi 4 and 5 versions: "Error reading frmWait.DesignSize. Property does not exist." was fixed.
  2. Problem with not correct getting IndexDef.Options for open table is fixed.
  3. Problem with converting LargeInt field to Varchar while restructuring table was fixed.
  4. Problem with incorrect handling "?" in default value was fixed.
  5. Problem with default value for Memo/Blob field last in a record was fixed.
  6. ExportToSQL bug with Unicode was fixed.
  7. Problem with staying lock after update of corrupted table was fixed.
  8. DBImportExport bug with not importing Indexes was fixed. 

- version 6.00 (11/09/2008)

  New features added:
  Delphi 2009 and C++ Builder 2009 support.

- 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ó if Database Name property of TABSDatabase component is blank in Delphi 5 is added.
  5. If the result of the <scalar subquery> is empty, then it returns the null value instead of raising error.
  6. SQL params for table name are supported now.
  7. Problem with invalid handling of timestamp fields in Delphi 4, 5 and C++ Builder 4,5 is solved.
  8. Bug with variant array having of size=1 passed to the Locate method is fixed.


- version 4.89 (06/16/2005)

  New features added:
  1. DBImportExport utility is improved.
  2. SQL INSERT command now supports inserting multiple rows by one statement.

  Bugs fixed:
  1. Bug with the quantity of fields in a query with the TOP clause is fixed.
  2. Parenthesis problem with EXISTS subquery is solved.
  3. MaxIndexedSize validation is added.
  4. Bug with join having condition on a single field is fixed.
  5. Bug with refresh after rollback is fixed.
  6. Support of SQL params for table name is added.


- version 4.88 (05/26/2005)

  Bugs fixed:
  1. Bug with columns naming in SQL JOIN with TOP option is fixed.
  2. Opening form with connected TABSDatabase component settled with invalid database path is now possible.
  3. Problem with error 20253: Cannot retreive record for index is solved.
  4. TOP option in subqueries is now handled properly .
  5. Bug with refresh after rollback is fixed.
  6. Problem with using bookmarks with DevExpress QuantumGrid is solved.
  

- version 4.87 (04/22/2005)

  New features added:
  1. DBManager now is capable to run very large SQL scripts which cannot fit to RAM.
  2. EXTRACT SQL function is added.
  3. ISO date format (YYYY-MM-DD) is now supported.

  Bugs fixed:
  1. Bug with StringField <> 'str_const' and null fields is fixed.
  2. Problem with open queries after rollback is solved.
  3. Problem with Blob fields in SetKey method with multi-user mode is solved.
  4. Comparison with the NULL const is now handled properly .
  5. Bug with the default time field value '00:00:00' is fixed.
  6. Error in query execution after incorrect table open is fixed.
  

- version 4.86 (03/18/2005)

  New features added:
  1. COALESCE SQL function is added.
  2. ZLib compression speed is increased.
  3. Performance of inner join on filtered tables is improved.

  Bugs fixed:
  1. BatchMove bug with the master-detail on the destination table is fixed.
  2. Setting MaxConnections to zero is disabled.
  3. Conditions like StrField > '' are now handled properly.
  4. Displaying of DBManager forms on system with large fonts is improved.
  5. Master-detail bug with empty table is fixed.
  6. Bug with sequential rollbacks is fixed.
  7. Bug with applying multi-fields index for query optimization is fixed.
  8. Error  30434 while accessing Blob fields as string is fixed.
  9. Field not found problem with GROUP BY query is solved.
  10. Problem with wrong data type of AVG on integer field is solved.
  11. Field names in brackets are now handled properly by SQL processor.
  12. Locate now autoconverts integer and double data types for DateTime fields.
  

- version 4.85 (02/15/2005)

  New features added:
  1. Unicode support for Win95/98/Me is added.
  2. FindKey, SetRange performance is improved for network databases.

  Bugs fixed:
  1. ExportToSQL bug with time fields is fixed.
  2. Autoinc options in SQL statements are now supported.
  3. Integer overflow error in Win95/98 is fixed.
  4. Bug with WideString conversion to ANSI string in restructuring is fixed.
  5. foCaseInsensitive option is now handled properly by the TABSQuery component.
  6. "Cannot free not commited pages" problem is solved..
  7. ABSDecConst unit is renamed to avoid naming conflicts with another components.
  8. ABSDecConst unit is renamed to avoid naming conflicts with another components.
  9. Alter table now works correctly with a session component.
  10. BatchMove bug with the master-detail on the destination table is fixed.
  11. Alter table now works correctly with a session component.
  12. Bug with distinct and nested left joins is fixed.
  13. Problem with NULL in CASE SQL operator is solved.
  14. Problem with updating in-memory table after batchmove is solved.
  15. GUID data type now doesn't require size parameter in CREATE TABLE SQL statement.
  

- version 4.84 (12/28/2004)

  New features added:
  1. SQL performance is improved.

  Bugs fixed:
  1. Problem with null value of calculated fields is solved.
  2. Null in SQL parameter is now supported.
  3. ReadOnly detection bug is fixed.
  4. Bug with null in arithmetic SQL expressions is fixed.
  5. WideString is now supported in calculated fields.
  6. Problem with subselect from grouped query is solved.
  7. Refresh bug with OnFilterRecord is fixed.


- version 4.83 (11/24/2004)

  New features added: 
  1. Delphi 2005 support is added.
  2. Absolute DB manual is extended.
  3. SQL syntax improvement: "Table . Field" construction with spaces is now supported.

  Bugs fixed:
  1. Problem with offline printer error in DBManager  is solved.
  2. Bug with unnecessary table unlock in transacted update is fixed.
  3. Repair with custome session bug is fixed.
  4. Invalid bit no problem is solved.
  5. Bug with GROUP BY subquery is solved.


- version 4.82 (10/19/2004)

  New features added: 
  1. SQL performance is improved.
  2. Multi-thread speed with high load is increased.

  Bugs fixed:
  1. Outer join bug with multiple join conditions is fixed.
  2. Problem with string field in aggregate functions is solved.
  3. Bug with SELECT DISTINCT is fixed.
  
  
- version 4.81 (10/13/2004)

  New features added: 
  1. 16 mathematical SQL functions are added.
  2. TRUNCATE TABLE SQL command is now supported.
  3. SQL performance is improved.

  Bugs fixed:
  1. Problem with SELECT DISTINCT command is solved.
  2. Chinese characters are now supported properly.
  3. Progress indication percentage is corrected in compact and repair procedures.
  4. Multi-thread access bug is fixed.


- version 4.80 (09/15/2004)

  New features added: 
  1. SQL performance is improved.
  2. IF NOT EXISTS option is added to CREATE TABLE and ALTER TABLE ADD commands.
  3. IF EXISTS option is added to DROP TABLE command.

  Bugs fixed:
  1. Problem with INSERT SELECT DISTINCT command is solved.


- version 4.79 (08/30/2004)

  New features added: 
  1. SQL uncorrelated IN subquery speed is increased.
  2. DBImportExport utility is improved.

  Bugs fixed:
  1. Problem with deleting small BLOB fields is fixed.
  2. Bug with temporary index is fixed.
  3. Memory table problem is solved.


- version 4.78 (08/24/2004)

  New features added: 
  1. UPDATE SQL command speed is improved.
  2. ORDER BY clause is now supported in UNION statement.
  3. Delete record speed with in-memory table is increased.

  Bugs fixed:
  1. Problem with SQL join is fixed.
  2. Bug with SQL union is fixed.
  3. Master-detail problem with non-default session is solved.
  4. Problem with SQL aliases is solved.
  5. Bug with SQL functions applied to Memo field is fixed.
  6. Bug with SQL ORDER BY and WHERE with OR condition is fixed.
  7. Problem with DISTINCT and JOIN is solved.
  8. Bug with Blob format recognition on large pages is fixed.
  9. Bug with temporary table name is solved.
  10. Problem with GROUP BY and several UNIONs is solved.


- version 4.77 (08/10/2004)

  New features added: 
  1. Many new Delphi and C++ Builder demos are added.
  2. Absolute Database Manual is essentially extended.

  Bugs fixed:
  1. Problem with LastAutoInc function and extended autoinc types is solved.
  2. Bug with extended autoinc types and EXCEPT clause is fixed.
  3. Range bug is fixed.
  4. Problem with not cancelled edit in transaction is solved.
  5. Union bug with some data types is solved.
  
- version 4.76 (07/19/2004)
  Changes: 
  1. Developer's Guide and Reference are replaced by the single help file: Absolute Database Manual.

  Bugs fixed:
  1. Problem with SQL join on three tables is fixed.

- version 4.75 (07/13/2004)

  New features added: 
  1. SQL DELETE statement speed is improved.

  Bugs fixed:
  1. Problem with small blobs on large database page is solved.
  2. Bug with Greek words in Lower and Upper SQL functions is fixed.
  3. SQL EXCEPT statement bug with memo fields is fixed.
  4. Size property value for WideString fields is corrected.


- version 4.74 (06/28/2004)

  Bugs fixed:
  1. Bug with open query on application close is fixed.


- version 4.73 (06/25/2004)

  New features added: 
  1. Memo field could be selected as string in SQL queries,
     for example via query like "select memo+'' from table".
  2. SQL performance improved.

  Bugs fixed:
  1. Problem with SQL full join is fixed.
  2. Bug with Like operator applied to WideString is fixed.
  3. DBManager AV issues are solved.
  4. BatchMove error is fixed.
  5. Memory bug with table having more than million records is fixed.
  6. SQL Group by problem is solved.
  7. Diagnostic message for invalid BlobCompressionMode specified is added.


- version 4.71 (06/09/2004)

  Bugs fixed:
  1. Error on DBManager/DBImportExport close is fixed.


- version 4.70 (06/07/2004)

  New features added: 
  1. Search/Filter/Navigation speed significantly increased.
  2. SQL performance improved in many kinds of queries.
  3. DBManager interface is improved.

  Bugs fixed:
  1. SQL Full Join problemis solved.
  2. TClientDataset compatibility bug is solved.
  3. Issue with RequestLive=False is solved.
  4. Refresh bug is fixed.
  5. Closing all tables without closing DB now works properly.
  6. BatchMove progress message is corrected.


- version 4.60 (05/13/2004)

  New features added: 
  1. TABSDatabase.FlushBuffers method is added.

  Bugs fixed:
  1. SQL outer join bug with OR conditions is fixed.
  2. SQL SELECT FROM SELECT field renaming bug is fixed.
  3. SQL join filtering problem is solved.
  4. Commit error with KeepConnection=false is solved.
  5. SQL group by with expression fields problem is solved.
  6. TABSQuery.Refresh problem with read-only data is solved.


- version 4.50 (04/22/2004)

  New features added: 
  1. TABSDatabase.MakeExecutableDatabase method is added.
  2. SQL query execution speed is increased in some cases.

  Bugs fixed:
  1. Bug with renaming several fields having the same name 
     in SQL SELECT query is fixed.
  2. SQL query problem with read-only database is solved.
  3. ImportTable bug is fixed.
  4. Insert SQL parsing error with colon is fixed.
  5. Restructure table now doesn't rename table if it is failed.


- version 4.40 (04/14/2004)

  New features added: 
  1. TABSTable.BatchMove interface is changed. bmtSynchronize mode is added.
  2. TABSDatabase.DisableTempFiles property is added.
     Use DisableTempFiles to ensure that database engine stores all temporary data in memory. 
     Before opening the database, set DisableTempFiles to true. 
     The default value for DisableTempFiles is false, 
     allowing database engine to create temporary files and 
     to reduce memory consumption when a large amount of data 
     is being operated (large BLOBs, large SQL query result).

  Bugs fixed:
  1. SQL params bug is fixed.
  2. Progress window is suppressed when lengthy "insert select"
     SQL query is being performed.
  3. Problem with ftLargeInt fields is solved.
  4. ALTER TABLE issue with removing indexes is solved.
  5. SQL UNION bug with empty dataset and filter is fixed.
  6. Memory leak with TABSQuery is removed.
  7. Problem caused by unmounting a network drive with 
     open database file on it is solved.
  8. Unicode problem in Win95/98/Me can now be handled correctly.
  9. Bug with SUM on null fields is fixed.
  10. Bug with SQL "group by" nested query is fixed.
  11. SQL "insert select" parenthesis handling is corrected.
  12. Subquery problem with table synonym is solved.
  13. Bug with empty scalar subquery is fixed.


- version 4.30 (03/31/2004)

  New features added: 
  1. Select from multiple databases is now supported.
  2. Password parameter is addded to the TABSTable.CopyTable.
     Now it is possible to copy table to the encrypted database. 

  Bugs fixed:
  1. Problem with database file > 2 Gb is solved.
  2. SQL Select bug with filter and index on several fields is fixed.
  3. DBManager bugs with table indexes creation are fixed.
  4. SQL problem with CURRENT_TIME function is solved.


- version 4.20 (03/19/2004)

  New features added: 
  1. UPDATE SQL statement now supports subqueries.

  Bugs fixed:
  1. Import progress dialog during the lengthy SELECT INTO query
     is suppresed. 
  2. SQL left join issue is solved.
  3. INSERT SELECT bug with the AutoInc field is fixed.
  4. DBManager bug while restructuring a table with 
     long field names is fixed.
  5. Delphi demos compilation in Delphi 4 problem is solved.


- version 4.10 (03/12/2004)

  New features added: 
  1. CASE SQL expression is added.
  2. ExportToSql method is added to TABSTable component.
     Now it is possible to make reverse engineering of a table.
  3. DBManager is improved.

  Bugs fixed:
  1. SQL JOIN bug with NULL link is fixed.
  2. INSERT INTO problem is solved.
  3. Close table at design-time now doesn't clear IndexDefs property.
  4. Old database conversion problem is solved.
  5. RestructureTable method now renames fields without data loss.
  6. BatchMove bug is fixed.
  7. SQL params problem is solved.


- version 4.00 (03/05/2004)

  New features added: 
  1. Correlated and non-correlated SQL subqueries are supported. 
     See Subqueries topic in Developer's Guide for more details.
  2. IN SQL operator now can be used with subquery.
  3. EXISTS SQL operator is added.
  4. Examples of SQL subqueries are added to 
     DBManager\SQL folder.
  5. TABSTable.BatchMove procedure with appropriate events 
     is added to perform batch records move operations.
  6. BatchMove Delphi demo is added.
  7. LIKE operator now can be used with MEMO field.
  8. DBManager is improved.

  Bugs fixed:
  1. SQL JOIN and UNION bugs with empty table are fixed.
  2. DISTINCT problem with index is solved.
  3. Click on IndexName property at design-time 
     now doesn't clear IndexDefs property.


- version 3.21 (02/12/2004)

  Bugs fixed:
  1. SQL Insert problem with memo field is solved. 
  2. Unnecessary database file growth is removed.


- version 3.20 (02/11/2004)

  New features added: 
  1. Import and export progress events are added.

  Bugs fixed:
  1. CompactDatabase now works correctly with varbytes fields.
  2. CAST now supports conveting to string data type 
     with specified size.
  3. "Blob cache not released" problem is solved.
  4. Unnecessary repair request is removed.


- version 3.10 (02/05/2004)

  New features added: 
  1. SQL ORDER BY clause support for field numbers.
  2. CHM file for printable Developers Guide is added.
  3. DBManager interface is improved.
  4. Protection to prevent user from opening one database file in 
     single-user mode and multi-user mode simultaneously is added.

  Bugs fixed:
  1. SQL CREATE TABLE with nonamed primary and secondary indexes 
     issue is solved.
  2. Division by zero error bug while 
     copying many empty tables is fixed.
  3. Bookmark problem with InfoPower controls is solved.
  4. Compound primary key now doesn't prohibit null value 
     of some its fields.
  5. RenameField bug is fixed.


- version 3.00 (01/27/2004)

  New features added: 
  1. Multi-user support is added, including record-level locking. 
     See MultiUser and MaxConnections property of TABSDatabase.
  2. Transactions with ReadCommited isolation level are implemented. 
  3. MultiUser Delphi demo is added.
  4. SQL and filtering analyzer is improved.
  5. DBManager utility is improved.
  6. Default progress displaying is added for potentially lengthy operations, 
     such as database compacting, table restructuring, etc. 
     These progress indicators could be switched off by 
     TABSdatabase.SilentMode property.
  7. Examples of SQL scripts are added into Utils\Bin\SQL directory.
  8. SQL transaction statements are now supported: 
     START TRANSACTION, COMMIT and ROLLBACK.

  Bugs fixed:
  1. CopyTable bug with copying into other database file is fixed.
  2. Problem with import indexes from DBase tables is solved.
  3. Issue with changing Filter property with active filter is solved.
  4. In-memory table is now deleted in design-time when it is inactive.
  5. Bug with 'like' search is fixed.


- version 2.10 (01/12/2004)

  New features added: 
  1. GUID field type is now supported.
  2. Absolute DBManager now can run SQL queries in database without tables.

  Bugs fixed:
  1. Problem with C++ Builder 6 compilation is solved.
  2. Issue with SUM SQL aggregate function on empty set is solved.
  3. SQL params objects auto-creation is added.


- version 2.00 (12/24/2003)

  New features added: 
  1. Absolute Database is now thread-safe. TABSSession component is added.
  2. In-memory tables are now supported. TABSTable.InMemory property is added.


- version 1.30 (12/22/2003)

  New features added: 
  1. Absolute DBManager utility interface is improved.

  Bugs fixed:
  1. Problem with Delphi 6 installation is solved.
  2. Bug with search using multi-fields index is fixed.


- version 1.20 (12/18/2003)

  New features added: 
  1. Filtering speed with large result 
     (10'000 - up to several millions of records) is imporved.
  2. SQL SELECT performance improved.
  3. Print table structure action is added to 
     Absolute DBManager utility.

  Bugs fixed:
  1. Bug with SQL function Length is fixed.


- version 1.10 (12/15/2003)

  Bugs fixed:
  1. Setting TABSTable.RecNo now works properly.


- version 1.00 Beta (12/09/2003)
=================
www.downloadly.ir