News
Improved handling of default values
Release notes for version 2.3.1 on May 26, 2012
Improved handling of default values
When the value of a field contains DBNULL, NULL or an empty string, the field’s default value defined in the FlowHeater Definition will now be used.
New numeric data type DOUBLE
Release notes for version 2.3.0 on May 7, 2012
New numeric data type DOUBLE
The existing FlowHeater numeric data types INTEGER, DECIMAL and CURRENCY were optimized for financial mathematics to avoid the occurrence of rounding differences. A new data type DOUBLE is now introduced for the higher precisions required in scientific calculations. The FlowHeater DOUBLE data type can process the SQL data types of float, real, single and double.
New export option for the TextFile Adapter
Release notes for version 2.2.6 on April 10, 2012
New export option for the TextFile Adapter
The TextFile Adapter has supported appending to existing text files on the WRITE side (export) for some time. Until now column field names were never added a second time to an existing text file. As of this version you can specify, in the case of appending to an existing file, whether column headings should be suppressed or not.
Calculations on date and time fields
Release notes for version 2.2.5 on January 30, 2012
New AddDays Heater
Using the AddDays Heater values can be added to date and time fields, or when negative, subtracted from them. Calculating with days, as suggested by the name of the Heater (function) is not all. By amending the default option in the configuration popup, you can also offset dates by years or months and times by hours, minutes or seconds.
TextFile Adapter with optimized preview
Release notes for version 2.2.4 on January 16, 2012
TextFile Adapter with optimized preview function
A preview in the TextFile Adapter in the export mode on the WRITE side is only shown when this is explicitly confirmed as wanted (click in the preview area). This significantly speeds up the processing of large CSV database export Definitions. It prevents extra accesses to records on the READ side being needed, because these could result in additional maintenance of the database server.