Hello

I have a SQL like this:

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

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.
Is there a better way to write instead of ELSE ' ' ELSE #.... ?



Greets
Calivers

Calivers,

<< 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.>>

What version of DBISAM are you using ?  Also, are you sure that the NULL
bytes are not coming from one of the existing field values that you're using
in the IF() ?  If you could email me the table that you're using
(timyoung@elevatesoft.com) so that I can try it here, I would really
appreciate it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim
I'm using 4.24 B1 with D7. I sent you a little Demo which hopefully
reproduces the problem,
Greets Calivers

Luis,

<< I'm using 4.24 B1 with D7. I sent you a little Demo which hopefully
reproduces the problem, >>

Okay, the problem is the IF expression and NULL memo values.  A fix will be
in the next build.  Right now I'm going to try and get that build out in the
first week of August.

--
Tim Young
Elevate Software
www.elevatesoft.com