 - added
 - fixed
 - changed
|
|
| Jan 20, 2006 build 2.6.3 |
|
|
|
|
added support for Delphi 2006 |
|
|
|
|
|
|
| Oct 20, 2005 build 2.6.1 |
|
|
|
|
Full-qualified table names (dbname@server:owner.table) now are supported in TIfxTable |
|
|
|
Field names were not trimmed in TIfxTable if connected to Informix 7.x family |
|
Master-detail didn't work correctly in unidirectional mode |
|
|
|
Now detail retains record position after master refresh |
|
|
| Oct 20, 2005 build 2.6.2 |
|
|
|
|
Synonyms support in TIfxTable |
|
|
|
Problem in TIfxTable on ANSI database with tables that have same name but belong to different users |
|
|
|
|
| Aug 18, 2005 build 2.6.0 |
|
|
|
|
the RefreshLocates property. Controls the cursor positioning method after the Refresh method call |
|
|
|
Access Violation navigating over the InfoPower grid |
|
TIfxTable reported string field size 1 character bigger than it is in a database |
|
Minor issues with TIfxTable master/detail link |
|
|
|
|
| Jun 22, 2005 build 2.5.1 |
|
|
|
|
|
|
Datasets were editable in UniDirectional mode - have to be non-editable |
|
Character fields after record refresh (RecordRefreshMode is rmInserted or rmPosted) always contained trailing spaces regardless of TrimStrings value |
|
TIfxTable incorrectly defined field size for not-null INTERVAL, DECIMAL, MONEY, DATETIME columns |
|
|
|
|
| Jun 09, 2005 build 2.5.0 |
|
|
|
|
The MaxTime property has been added to PoolOptions. The property specifies how long an idle connections will be live even if the total connection count is less than Min value. This allows to force connection close when there are some network restrictions like the idle network connection lifetime limitation |
|
The CommitUpdates method and the AutoCommitUpdates property have been added to all dataset components |
|
The connection pool demo has been added |
|
|
|
Random access violation on disconnect if LoginPrompt is True and pooling is disabled |
|
Access violation on change post to database in TIfxTable, TIfxQuery and TIfxDataSet opened in the RequestLive mode (appears in 2.4.2) |
|
|
|
TIfxConnection's ApplypUpdates now clears datasets' cached updates cache only if all updates were applied successfully |
|
The Locate and LocateNext methods now cast key values to the corresponding fields types (previous versions cast the field value to the key value type). As an example this enables to find a record with the integer field value equals to 8 by the string key value '08' |
|
|
| May 10, 2005 build 2.4.2 |
|
|
|
|
|
|
Selecting complex datatypes (set, list etc.) causes access violation when Informix connectivity less than 2.80 is used |
|
Read-only fields refresh error |
|
Cannot set null to a calculated field |
|
Field value change doesn't fire the OnValidate event |
|
SQL auto-generation for datasets with defined index fields incorrectly handles null values |
|
|
|
Locate and Lookup optimizations for null keys |
|
|
| Apr 20, 2005 build 2.4.1 |
|
|
|
|
|
|
"Cannot open dataset in RequestLive mode" issue on TIfxTable open |
|
|
|
|
| Apr 19, 2005 build 2.4.0 |
|
|
|
|
TIDACEvents component has been added |
|
OnGetTableName property in all dataset based components. Occurs when a dataset initializes its information about the table to which it applies updates when SQL is auto-generated |
|
TIfxConnection.GetPoolStats method. The method can be used to get usage statistics of the connection pool corresponding |
|
|
|
"Cannot open dataset in RequestLive mode" issue on TIfxQuery load |
|
|
|
|
| Apr 04, 2005 build 2.3.1 |
|
|
|
|
|
|
"-402 Address of a host variable is NULL" error on execution of a statement that was unprepared before |
|
Access violation issue on DATABASE statement execution if there are opened cursors |
|
|
|
|
| Mar 31, 2005 build 2.3.0 |
|
|
|
|
|
|
|
|
Calculated fields now can be optimized by setting AutoCalcFields to false, in this mode dataset component will calculate fields for a record only once when a record is retrieved from a database |
|
RecordCount property now forces the FetchAll method call to return a valid result, also if dataset is filtered then result is corresponding to the filtering applied |
|
|
| Mar 25, 2005 build 2.2.1 |
|
|
|
|
DeletePool and DeletePools methods in TIfxConnection can be used to close all pooled connections |
|
GetStoredProcNames method in TIfxConnection |
|
TIfxStoredProc component has been added |
|
SQLProcessor and Macros properties have been added to TIfxTable, TIfxDataSet |
|
|
|
#0 symbol was returned at the end of the value string for complex data types (set, list etc.) |
|
|
|
TIfxQuery.ExecSQL, TIfxStoredProc.ExecProc and TIfxSQL.Execute can be called for statements that return results and in such case behaves like the SPL's SELECT ... INTO ... (or EXECUTE ... INTO ...) statement. The call results can be accessed by the Results property for TIfxQuery and TIfxStoredProc and by the Fields property for TIfxSQL |
|
If the value returned by the SELECT statement is converted by the server to the string type (for example SELECT 123::lvarchar FROM systables), some Informix server versions report that the column has zero length.Workaround has been added - such column is interpreted as a column with default length for the corresponding data type |
|
|
| Feb 22, 2005 build 2.1.0 |
|
|
|
|
|
|
Trial warning in registered versions |
|
Access violation issue in some cases when Fields is not equal to the SQL statement results |
|
Access violation and "Invalid pointer operation" after using a string parameter |
|
Access violation when using the UseTimeOut property |
|
Empty string parameter stored as NULL instead of the '' value |
|
Access violation on TIfxDataSet open |
|
C++Builder compilation issue with IfxConnection.hpp |
|
|
|
|
| Feb 08, 2005 build 2.0.0 |
|
|
|
|
Advanced BLOB/CLOB support has been added (TIfxLob class and others, see IfxLob unit). New field types TIfxBlobField and TIfxClobField |
|
Serial field values for an instered record now can be updated by the dataset. Just set the AutoGenerateValue Field's property to the arAutoInc value and dataset will update value after an insert |
|
|
|
Issue with components that change the order of fields in Fields (for instance InfoPower) |
|
Access violation on values set to TSmallIntField and TDateField |
|
|
|
|
| Release status has been achieved |
|
|
|
|
|
|
|
| Dec 10, 2004 build 2.0.0 beta 2 |
|
| New components: TIfxSQLProcessor, TIfxFieldTypes, TIfxCompositMonitor, TIfxFileMonitor, TIfxVisualMonitor |
|
|
|
|
|
|
|
| TIfxConnection |
|
|
The DesignConnection property. The Connected property is always False after a component loading in runtime if DesignConnection is set |
|
The FieldTypes propery defines the default TIfxFieldTypes instance for the all linked components |
|
The Monitor property (any of TIfxCompositMonitor, TIfxFileMonitor or TIfxVisualMonitor) |
|
The PoolOptions property. Specifies whether to use a pool for the connection and describes pool parameters |
|
The StatementCache property. Defines a size of a cache for prepared handles of the most recently used SQL statements |
|
The ShareCursorStatement property. Used by the statement cache, if is set then cursors opened for the same SQL statements use the same statement handle |
|
The SQLProcessor property defines the default TIfxSQLProcessor instance for the all linked components |
|
|
|
|
|
LoginPrompt is False by default |
|
The TableTypes enumeration has been extended |
|
|
| TIfxSQLProcessor component is used for the SQL generation and parsing |
|
|
The MacroChar property specifies a character to be used to define a macro in a SQL statement |
|
The Macros property defines a collection of macro definitions to be used while SQL parsing |
|
The ParamChar property specifies a character to be used to define a parameter in a SQL statement |
|
|
|
|
|
|
| TIfxFieldTypes component is used to map Informix data types to Delphi field type enumeration. Also the component allows to force usage of the IDAC fields instead of the standard ones (TIfxCharField, TIfxDecimalField etc.) |
|
|
|
|
|
|
|
| TIfxCompositMonitor, TIfxFileMonitor, TIfxVisualMonitor components are used to register messages between IDAC components and a database server |
|
|
|
|
|
|
|
| TIfxTable, TIfxQuery, TIfxDataSet |
|
|
The CacheHandle property. If is set then SQL statement can be taken from the statement cache |
|
The DesignActivation property. The Active property is always false after the component loading in runtime if DesignActivation is set |
|
The FieldTypes property (TIfxFieldTypes) |
|
The PacketRecords property. Use PacketRecords to specify how many records should be fetched from a database at one time |
|
The RecordRefreshMode property. Defines whether dataset have to refresh record values after appling update to a database |
|
The UpdateOptions property. Use this property to enable SQL auto-generation for updates, to force transaction start for updates, to check updated record count |
|
The AfterApplyUpdates, BeforeApplyUpdates, OnUpdateApply, OnRefreshRecord events |
|
|
|
|
|
|
| TIfxQuery |
|
|
The RequesLive property |
|
The SQLProcessor property |
|
The Macros property defines a collection of the macro definitions to be used while SQL parsing (overrides values of a corresponding TIfxSQLProcessor) |
|
|
|
|
|
|
| TIfxDataSet |
|
|
The RequesLive property |
|
The RefreshSQL property |
|
|
|
|
|
|
| TIfxUpdateSQL |
|
|
The RefreshSQL property |
|
|
|
|
|
|
| TIfxSQL |
|
|
The CacheHandle property. If is set SQL statement can be taken from the statement cache |
|
The SQLProcessor property |
|
The Macros property defines a collection of the macro definitions to be used while SQL parsing (overrides values of a corresponding TIfxSQLProcessor) |
|
The Scrollable property. Use Scrollable property to open scrollable Infromix cursors. In this mode Prior, MoveTo and MoveBy methods are available |
|
MoveTo, MoveBy and Prior methods |
|
|
|
|
|
|
|
|
|
|
|
All known bugs |
|
|
|
|
| Sep 06, 2004 build 1.1.17 |
|
|
|
|
|
|
conversion error when selecting DATETIME ... TO FRACTION(x) values |
|
|
|
|
| Aug 23, 2004 build 1.1.16 |
|
|
|
|
|
|
conversion error when selecting DATETIME data type with YEAR TO... values |
|
|
|
|
| Aug 18, 2004 build 1.1.15 |
|
|
|
|
|
|
access violation on IDAC's DataSet based component close if selection contains SMALLFLOAT data type |
|
TIfxTable.IndexDefs doesn't report column if it is last in table |
|
fixed converson error when selecting DATETIME data type values |
|
|
|
TIfxSQL.Close method now commits transaction if database is in Ansi log mode and TIfxConnection's AnsiAutoCommit property is set to true |
|
|
| Aug 10, 2004 build 1.1.14 |
|
|
|
|
new isolation levels: ilUnchanged, ilDirtyRead, ilCommitedRead, ilCursorStability and ilRepeatableRead (new default value is ilUnchanged) |
|
|
|
access violation on connect when INFORMIXSERVER environment variable is not set |
|
disconnect issue with Informix Online 5.0 servers |
|
transaction start issue in some system environments, caused by isolation level setting |
|
issue with TClientDataSet.ApplyUpdates (IDAC didn't save changes into a database) |
|
issue with Filter and Filtered in TIfxTable. When changing values on a closed IfxTable that was already opened, followed Open didn't use new Filter settings |
|
|
|
|
| Jul 29, 2004 build 1.1.13 |
|
|
|
|
property in TIfxConnection
|
| IsUniversalServer | boolean property indicates whether Informix server belongs to the 9.xx family |
|
|
|
|
|
simple type parameters (Double, Integer, Int8, Single, SmallInt) issue. In some system environments incorrect data passed to a database server |
|
access violation problem on database change or disconnect (appears in build 1.1.12) |
|
|
|
all files now have names with Ifx prefix (except lx.inc, LXDelegat.pas and LXIDAC.pas), to avoid possible problems with non IDAC units but with same names (for example login.pas) |
|
|
| Jul 22, 2004 build 1.1.12 |
|
|
|
|
methods, properties and changes in TIfxConnection
|
| OpenDatabase | allows changing of active database without reconnect |
| CloseDatabase | close active database |
| ServerVersion | server version connected to |
| SessionID | connection's session ID on a database server (same as onstat command displays) |
| CommitRetain | from now True by default |
|
|
|
|
|
NCHAR/NVARCHAR last character loss issue |
|
|
|
|
| Apr 15, 2004 build 1.1.11 |
|
|
|
|
|
|
Locate bug. Affected IfxCustomDataset.pas |
|
|
|
|
| Mar 03, 2004 build 1.1.10 |
|
|
|
|
|
|
bookmark bug |
|
|
|
installation process, help and supplementary files have been changed slightly |
|
|
| Feb 26, 2004 build 1.1.9 |
|
|
|
|
|
|
"A syntax error has occurred" while TIfxTable component opening on Informix Dynamic Server |
|
"Invalid field size" while field definitions initialization in TIfxTable component |
|
|
|
TIfxSQL.RowsAffected now returns value from Informix API for all statement types not only for SELECT, INSERT, UPDATED and DELETE |
|
|
| Nov 27, 2003 build 1.1.8 |
|
|
|
|
history file |
|
|
|
|
|
help files updated |
|
|
| Nov 25, 2003 build 1.1.7 |
|
|
|
|
TIfxCustomDataSet.TrimStrings property along with string trimming feature for character fields |
|
properties and events in TIfxConnection
|
| AnsiAutoCommit | specifies whether the connection should commit transaction on ansi database after every statement execution |
| TransactionActionOnClose | specifies what action a connection should take upon closing when there are active transactions left |
| CommitRetain | specifies whether opened cursors will be closed or left opened after transaction commit or rollback |
| IsTransactionsSupported | indicates whether transactions is supported by currently connected database |
| IsAnsiDatabase | indicates whether currently connected database log mode is ansi |
| IsInformixOnline | indicates whether currently connected server belongs to Informix Dynamic Server family |
|
| OnCloseError | occurs after an exception is raised while closing connection |
|
|
|
events in TIfxSQL and TIfxCustomDataSet
|
| OnCloseError | occurs after an exception is raised while statement or dataset closing |
| OnUnprepareError | occurs after an exception is raised during statement unprepared |
|
|
|
|
|
invalid pointer operation issue. Took place with specific processing of smallint field |
|
invalid field size issue. Tooke place with specific processing of fields with data type that contains precision |
|
two memory leak bugs |
|
bug with lookup fields |
|
-1800 error on close |
|
bug with TIfxTable component on Informix SE |
|
|
|
|
| Jul 02, 2003 build 1.1.4 |
|
|
|
|
support of queries spanning over different databases functionality, for example:
SELECT * FROM database2@server2:table2
while connected to "database1@server1" |
|
classes in IfxSQL unit:
- TIfxParam
- TIfxParams
- TIfxField
- TIfxFields
|
|
|
|
bug in TIfxConnection.StartTransaction method |
|
bug in TIfxTable, TIfxDataset related to blob/text routine |
|
bug in TIfxSQL.ExecuteDirect method |
|
bug in ftDateTime/DTIME conversion |
|
|
|
TIfxConnection component editor |
|
minor source code optimization |
|
classes:
- TIfxConnection
- TIfxSQLVAR
- TIfxSQLDA
- TIfxSQL
- TIfxCustomDataset |
|
|
| Mar 17, 2003 build 1.0.6 |
|
|
|
|
|
|
|
|
bookmark handling |
|
|
| Mar 14, 2003 build 1.0.5 |
|
|
|
|
|
|
|
|
error handling |
|
|
| Mar 09, 2003 build 1.0.4 |
|
|
|
|
SQL query execution break |
|
UseTimeOut property |
|
|
|
bug for ftDate parameter |
|
|
|
Interruptible property has been removed |
|
help was updated |
|
|
| Feb 09, 2003 build 1.0.1 |
|
|
|
|
property Value (Variant type) in TIfxSQLVAR |
|
type ftFixedChar has been supported |
|
|
|
bug concerned INT8 data conversion (TIfxSQL.GetAsInt64) |
|
|
|
updated Decimal.pas and Int8.pas units |
|
TIfxConnection component editor has been improved |
|
TIfxUpdateSQL component editor has been improved |
|
|
| Jan 14, 2003 build 1.0.0 |
|
|
|
|
release status has been achieved |
|
|
|
|
|