changelog.eng

delphi通过OCI访问ORACLE

********************************
Project name:                           DOCI (DelphiOCI)

Resources: 
	Project Manager     Andrey Romanchenko [e-mail], [e-mail]

Description: 
  A list of changes and fixes groupped by version number in 
  chronological order. See dOCI_README.* in root folder for project description.

Bug reports:
  Please use the SourceForge bug tracking system at 
  http://sourceforge.net/projects/delphioci/. 



********************************
+ means "added"
- means "removed"
* means "fixed" or "modified"
********************************

CHANGE LOG
----------

v 1.21 (04 Mar 2007)

 * It is possible to read/write CLOB fields using ReadBlob/WriteBlob methods.
 * Removed exception in THarrayStringFix.CreateSize(Size: integer) in case if parameter Size is zero (0).
   It caused generating an exception during execuring queries like "SELECT NULL, * FROM Table1".
 * Improved automatic determining fields of the following types: ROWID, BLOB, CLOB, RDD (rowid
   descriptor), binary data, BFILE, LONG binary.
 * TADataSet's navigation methods EOF, First, Next, Prev made virtual.
 * Added rasing exception when method First is called and UniDirectional is True.
 * Unittests migrated to the dunit-9.3.0.
 * Added new unit tests.
 * Due to the problems with Proxies.pas, Delphi 7 packages are divided into 2 separate packages 
   (runtime and design). 
   dOCI7Runtime.dpk need to be compiled first (do not press Install button)
   dOCI7Design.dpk need to be compiled AND installed after dOCI7Runtime.dpk.

v 1.20  (12.10.2003)

 * Fixed compilation bug with variants and int64 type under Delphi 4,5.
 * Added new defines into DOCI.inc D5_OR_HIGHER D6_OR_HIGHER D7_OR_HIGHER.
 * Code formatting.
 * Several constant string were moved to the *.lang files.

v 1.19  (06.05.2003)

 * Fixed bug when error message "OCI not properly installed on this machine" has beed displayed
   when the application was run under login that doesn't have Administrator 
   rights.
 * Added public property SQLType that returns the type of the current SQL 
   query (select, insert, delete and so on). The value of this property is available after 
   Prepare call. The property become unavailable after UnPrepare call.
 * The following methods of TAField: DeleteRecord, InsertRecord, Allocate has been moved from
   protected to public area (to allow create tests on these methods). 
 * Fixed "Access violation" bug in methods TAField.GetAsXXXX if TAField.Allocate has not been called
   before.
 * Added check Size = 0 into constructor THArrayStringFix.CreateSize(Size:integer).
 * Method THArrayStringFix.IndexOfFrom() does not generate exception if parameter Start is out
   of bounds. The value -1 returns instead. 
 * Added tests for the following components: TAOraSQL, TOraSQL, TOraDB, TAParam, TAField, 
   THArrayStringFix.
 * Added check that AOraSQL is opened in method Fetch.
 * The FAQ is updated.
 * The Russian documentation is updated (files TOraDB.html, TADatabase.html, TADataSet.html).
 * The documentation of TOraDB and TADatabase components is available on English.
 * The documentation was separated into two parts: English and Russian. 
   Further I am going to support two version of documentation.
 * Fixed bugs in TAOraParam.GetValue.
 * Added support for Int64 in TAOraParam.GetValue and TAOraParam.SetValue.
 * Fixed bug in goodDelphi2Ora (UnMakeGoodDateTime was called with Integer parameter instead of
   Int64 when type ftoDateTime is asked).

v 1.18_2 (20.12.2002)

 * Support for Delphi 4 is added.

v 1.18_1 (06.12.2002)
 * File structure was changed for convenient. Some files were moved to the new directories.

v 1.18 (01.12.2002)
 * added clearing FieldDefs and Fields on change query.
 
v 1.17 (5.11.2002)
 * All "raise Exception.Create()" were replaced by raise "EDatabaseError.Create(...)".
 * EOraError derived from EDatabaseError.

v 1.16 (not available)
 * Method OpenAll became virtual and moved to the TADataSet.
 * Improoved internal processing of FieldDefs and Fields in TDataSetQuery (VOpen & VInitFieldDefs).
 * Fixed bug with ValuesNull in TOraField.add.
 * Property Preferences was added into TOraDB.
 * Properties RollbackOnDisconnect, ConnectAs, SQLTrace were added into TOraDB.
 * Added new unit OraUtils.pas with various useful functions.
 * Functions ADatabaseError and ADatabaseErrorFmt were moved from ADataSet.pas to OraError.pas.
 * Two new error messages sOraErrOCIVersionInfoAbsen and sOraErrOCINotInstalled are added into 
   .lang files.
 * Added property editor for TOraDB.DBServer property. There is a combo box with SQL*Net8
   aliases from tnsnames.ora file.
 * Fixed bug if oci.dll is not in PATH variable. 
 * The registry is used to path to the oci.dll.
 * Automatic determining the oci.dll version.

v 1.15 (27.04.2002)
 *  All resource strings (error messages and etc.) moves to the one common 
    file dOCIMessages_YOURLANGUAGE.lang. Now it is easy to translate 
    message to the various languages. 
    To create messages file with your language you need
     to make a copy of any existing .lang file, 
     translate messages in it to needed language, 
     assign a properly name (dOCIMessages_YOURLANGUAGE.lang) to it,
     create (or uncomment) line {$DEFINE dOCI_YOURLANGUAGE} in dOCI.inc,
     add next lines in dOCIMessages.pas:
      {$ifdef dOCI_ENGLISH}
       {$INCLUDE  dOCIMessages_YOURLANGUAGE.lang}
      {$endif}
    Or you can send me your language file and I will include it in 
    distribute.
 *  Many little changes in AOraUpdateSQLEd.pas
 *  Property Active moved from TOraDB to TADatabase.
 *  Added abstract methods SetActive, GetActive, Open, Close in TADatabase.

v 1.14 (8.04.2002)
 *  Added example EditableSataSet (see folder Examples) which demonstrates 
    how to use dOCI components to make editable dataset
 *  Added property LoginPrompt to the TOraDB component.
 *  All functions ADatabaseError and ADatabaseErrorFmt was replaced by my 
    own ADatabaseError and ADatabaseErrorFmt from ADataSet.pas module.
v 1.13 (15.11.2001)
 *  Added documentation on Dynamic Arrays. See DynamicArrays.html and DynamicHashes.html.
 *  Some fixes and many additionals in DynamicArrays.pas.
v 1.11 (25.09.2001)
 *  Fixed error 'OCI no data' on TAOraSQL.Close() with Oracle 8.1.6 or higher.
 *  Some error messages moved to resourcestring constants at the begin of each module.
 *  Some comments added into source files.
 *  Some comments translated into English.
 *  Added check for the presence of all needed OCI functions in oci.dll in OraDB.pas.
    If one or more functions does not exists in oci.dll exception with list of absent
    function names raised.
v 1.10 (06.04.2001)
 *  Added virtual method CreateAField. Now TADataSet can hold list of fields descendances  
    of TAField.
 *  Removed method AddField from TAOraSQL. CreateAField works insted of AddField.
 *  Added check on empty query text. Now you will see instead of strange "Zero iteration 
    counter" "SQL statement is empty."
v 1.09 (19.03.2001)
 *  Added method OpenDatabase in AOraSQL.
 *  Added editor for AOraUpdateSQL as standart Delphi Query Editor. Now you don't need 
    to create queries by hands.

v 1.08 (27.02.2001)
 *  In error message errorcode appeared twice.
 *  Errors with code 20010-20050 are reserved for user information messages
    EOraError cuts all debug information from this messages.
    For additional information see OraError.pas
v 1.07 (08.01.2001)
 *  Events BeforeInitOCI and AfterInitOCI added. You can change OCI libriary 
    name, disable initialization.
 *  Property OraSessionIsolationLevel