New Features and Bug Fixes in Version 6.01 of ODBCExpress
=========================================================
New Features
------------
New features introduced since the previous version:
1. The THdbc connection component will now return the connection attributes
into a new public string list property called "RetAttributes" after a
successful connection was made. This will only work if the "InfoPrompt"
property is set to a value other than "No Prompt".
2. The THstmt statement component now allows you to provide a blob column value
in parts via the new OnBlobData event during an insert or update.
3. The functionality of the ApplyUpdates method used when working with cached
updates is now split across the two familiar methods called ApplyUpdates and
CommitUpdates. A property called "AutoCommitUpdates" (with a default value
of True) is added for backward compatibility. Once set to False, you have
to call the CommitUpdates method to clear the cache after a successful call
to ApplyUpdates.
Bug Fixes
---------
Bug fixes included since the previous version:
1. The StringTrimming functionality now works correctly in the TOEDataSet and
TOEQuery components if StringTrimming is set to a value other than
stTrimNone.
2. The overflow problem with numeric and decimal types is now fixed. Numeric
and decimal types with a "scale" of 0 were incorrectly converted to smaller
data types than those that can hold the full "precision" number of digits.
3. A problem in some of the overloaded BindParam methods that existed when
binding multiple parameters with same name is now fixed.
4. A problem with the ODBCExpressTools package in localized version of Delphi
is now fixed.
5. ODBCExpress now works correctly in a CLX application. The TOEIntFloat and
TOEDateTime data-aware controls were moved to a separate unit called ODCL
to enable usage of all the other ODBCExpress components in a CLX
application. Of course you won't be able to use these two data-aware
controls in a CLX application until a CLX-friendly alternative is provided.
6. A problem with positionally nulling existing blob fields in a result set
(that was thought to have been fixed in version 6.0) is now fixed. You can
now null the blobs using any level of positional operations, including
level 1 that makes use of ODBC function calls.
General Comments
----------------
Some important comments on the new version:
1. Please report any problems experienced with this new version to
support@odbcexpress.com so that it can be addressed as soon as possible.
2. The TOESchema component will now generate a default precision of 1 for
character columns and a default precision of 10 for decimal and numeric
columns when the defined precision is 0.
Acknowledgements
----------------
Thanks to everybody for all the suggestions and feedback which were instrumental
in the development of this new version of ODBCExpress. Also thank you to
Robert Sundström for his comments on default precision values.