View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap