Icon View Incident Report

Serious Serious
Reported By: Luzi Calivers
Reported On: 7/25/2006
For: Version 4.24 Build 1
# 2208 Combining Memo Fields and String Expressions in IF Function Can Cause Embedded NULL Characters

I have a SQL like the following. B_10,B_11 and B_12 are Memo Fields.

I inserted the resulting Field 'Ausgabe' into a string and saved the String to a file. The problem was, the file ended after the Field 'Ausgabe' with some strange chars.

After a long time, I found out, the resulting Field 'Ausgabe' contains #0-Chars. This seems to cut off the file.

When I write ' ' (Space) instead of '' (#0 Char ?) , after ELSE , it works.

SELECT PNL_FELD_BEZ,
      B_10 +
      IF (PNL_FELD_BEZ_VORH = TRUE THEN B_11 ELSE '') + B_12
      AS Ausgabe FROM Results



Resolution Resolution
Fixed Problem on 7/28/2006 in version 4.25 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image