Problem with NULL value in memo field
"Andrew Velline" <[email protected]> Mon, 31 Jul 2006 17:14:04 -0700
| Newsgroups | gmane.text.rlib.user |
|---|---|
| Organization | Kace Networks, Inc. |
| Message-ID | <000b01c6b4ff$667ac5a0$1802a8c0@andrew> |
When I have a field with memo="yes" in a report, it works fine as long as all the values are non-NULL in the result set, but if any rows contain NULL value in a memo column, the report crashes and does not generate any output. I'm using the pre-release 1.3.7 with MySQL I'm working around this by COALESCEing a "" string in my SQL to avoid the null values, but would like to know if this is a bug in RLIB or if there is another solution. Thanks ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rlib-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rlib-users