Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
#0 Chars in computed Field |
Sat, Jul 22 2006 9:11 AM | Permanent Link |
"Calivers" | 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 |
Sun, Jul 23 2006 6:38 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jul 25 2006 4:54 AM | Permanent Link |
"Calivers" | Hello Tim
I'm using 4.24 B1 with D7. I sent you a little Demo which hopefully reproduces the problem, Greets Calivers |
Wed, Jul 26 2006 12:19 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |