Advantage 10.0 update (10.0.0.3) is now available

A 10.0 update (10.0.0.3) is now available on the Developer's Zone Product Download Area.

10.0.0.3 - Advantage .NET Data Provider
This Service Update of the Advantage .NET Data Provider addresses the following issues:
  1. Added an Unprepare() method to the AdsCommand class of the Advantage .NET data provider to allow closing the SQL statement handle and releasing the tables opened on the server.
  2. Fixed a bug in the Advantage .NET Data Provider that caused connections to be destroyed rather than reused from the pool when the "Connection Lifetime" connection property was set to a non-zero value.
  3. Fixed a bug that caused the Visual Studio IDE to crash when creating a TableAdapter with a SELECT statement in which the table name case (upper/lower) did not match the name of the actual file on disk. The fix for this issue is in the server (Advantage Database Server and/or Advantage Local Server).
10.0.0.3 - Advantage Client Engine (ACE)
This Service Update of the Advantage Client Engine (ACE) addresses the following issues:
  1. Fixed a bug when restructuring DBF tables (ALTER TABLE) that resulted in DBF table headers losing the flag that indicated the existence of a structural (auto-open) index file.
  2. Improved logic of AdsSetScope to avoid 5088 error.
  3. Fixed a bug that caused incorrect Unicode characters being returned from or stored into a DBF table when the table is opened with ADS_OEM character type.
  4. Fixed an issue that prevented functions and packages from being renamed.
  5. Fixed a bug that caused an incorrect record to be deleted when setting the minimum value property of a field using a Unicode expression. This was the default behavior using the 10.0 release of ARC.
  6. Fixed a bug that caused 5003, 5071, 5079, or 5080 errors to be returned when restructuring a table or when copying the content from one table to another table.
10.0.0.3 - Advantage Crystal Reports Driver
This Service Update of the Advantage Crystal Reports Driver addresses the following issues:
  1. Modified the Crystal Reports driver to use the adsini_path environment variable to locate the ads.ini file.
10.0.0.3 - Advantage Data Architect (ARC)
This Service Update of the Advantage Data Architect (ARC) addresses the following issues:
  1. Fixed an issue where ARC would show up off the visible desktop if previously opened on a screen that was no longer attached.
  2. Changed "Export Tables to Code" functionality to use the correct lock type for the current database.
  3. Improved the dictionary compare tool handling of SQL Script stored procedures and FTS delimiter characters.
  4. Fixed an issue where the ARC "Tables To Code" functionality could generate invalid decimal values if the Windows locale decimal separator setting was not a period/dot.
  5. Fixed an issue where ARC would crash if loading trigger properties where the trigger script was large (over 5k).
  6. Fixed an issue where the ARC table browser could no longer correctly locate records via its search functionality if the index key included the + operator.
  7. Fixed issue with functions that have the same name, but exist in more than one package.
  8. Fixed ARC to include functions when generating an SQL script from the top level node.
  9. Fixed a bug that prevented the import process on a free connection from changing a column to an autoinc field.
  10. Fixed an issue where ARC would not re-open on a secondary monitor if the last time it was closed the main window was in the maximized state.
  11. Fixed upgrade scripts to not add subscription queue tables.
  12. Fixed a bug that truncated long SQL scripted stored procedures when viewing their properties.
  13. Fixed an issue where ARC would raise an exception "List index out of bounds" when loading a saved schema that included index definitions.
  14. Fixed an issue where ARC raised the exception "Unable to find memo block size table" when loading a saved schema if the schema was saved from an existing table's schema, instead of a schema that was created from scratch.
10.0.0.3 - Advantage Database Server
This Service Update of the Advantage Database Server addresses the following issues:
  1. Fixed a bug that allowed applications to store invalid IEEE floating point values in fields of type double.
  2. Fixed an issue that could cause a 5035 and 7078 error when multiple local server threads or processes were logging in as ADSSYS at the same time.
  3. Fixed an issue that can lead to a server crash after a corrupt index file is opened.
  4. Fixed an issue where the server could write a crash dump file when shutting down with active users currently committing a transaction.
  5. Fixed an issue where recalled (undeleted) DBF record operations were not replicated properly.
  6. Fixed a bug that caused mixed cased file name/extension to be stored in the data dictionary for the auto-open index files. The mixed cased file name could cause table open failures on Linux servers.
  7. Fixed an issue that could cause the server to deadlock and hang when shutting down with active users.
  8. Fixed a bug that may cause 4004 error when an index is built using expression with LEFT(), RIGHT() or SUBSTR().
  9. Fixed a bug that caused searching for an empty string or a string with all spaces on an Unicode field to fail.
  10. Fixed an issue where using a special character in a column alias name could cause the server to hang.
  11. Fixed a bug that caused the wrong result to be returned from an AOF that has Unicode columns in the expression, the exact setting of the table is off, and there are trailing spaces in the value of the expression.
  12. Fixed a bug that allowed tables to be deleted from the data dictionary while the table had active replication queue entries. This could occur if the base table name was longer than 24 characters.
  13. Changed the query engine to handle DOUBLE column definitions with 0, 1, and 2 parameters.
  14. Fixed a bug in the server that could result in the logging of a 9107 error.
  15. Fixed a bug that caused the system procedure sp_Reindex to fail with a 5175 error when reindexing dictionary-bound tables with a new collation.
  16. Fixed a bug in the server that could result in 9009 and 9057 internal errors if transactions were started in the context of a running trigger.
  17. Fixed a bug that can cause an incorrect Unicode value in a DBF table after rolling back records appended inside transaction.
  18. Fixed a 7041 error when executing SQL statements with an ORDER BY clause from clients older than 8.0.
  19. Fixed a bug in the server that prevented the use of column names over 10 characters long in VFP temporary (#tmp) tables.
  20. Fixed a bug in the SQL engine that caused string concatenation of NCHAR string with NCHAR or CHAR string to fail.
  21. Fixed an issue where using a parameter for the START AT value in a query could cause the server to crash.
  22. Fixed an issue where a static query can return the wrong results if using a <= or >= operator in the WHERE clause and the field reference is on the right side of the comparison.
  23. Fixed a bug that caused the contents of the __error results to be lost from AEPs (Advantage Extended Procedures) created with .NET.
  24. Fixed a bug that prevents an SQL query with GROUP BY on an expression using a user defined function from being executed. An example statement that failed to executed was: SELECT fn1( x ) FROM table1 GROUP BY fn1( x )
  25. Fixed a bug where the result of the CASE expression or IIF() scalar function in SQL query is evaluated incorrectly when the expression/scalar function include both Unicode string and ANSI string as potential results.
  26. Fixed a bug that caused a 2103 error to be returned when an SQL Union select query has Unicode character data in the result.
  27. Fixed a bug that could cause a trigger script to fail if the last statement executed in the script was a SELECT statement.
  28. Fixed a bug that caused query execution to fail when Unicode is the returned type of a subquery in an IN or NOT IN type of comparison.
  29. Fixed a bug that allowed package names to contains spaces.
  30. Fixed a bug that caused the scalar function Concat() to fail when one or both inputs are Unicode.
  31. Fixed a bug in the SQL engine that caused incorrect values to be assigned to an ANSI string variable when the value was Unicode character data.
10.0.0.3 - Advantage TDataSet Descendant
This Service Update of the Advantage TDataSet Descendant addresses the following issues:
  1. Fixed a memory overwrite in the TDataSet Descendant when Unicode fields are updated.