[Rlib-users] Problem with NULL value in memo field

[Andrew V. <an...@ka...>]

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