rlib-users

[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

 

 

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

[Bob D. <bd...@si...>]

Hi Andrew,

This should fix it:  http://www.sicom.com/~bdoan/rlib-1.3.7.tar.gz

- Bob

On Mon, 2006-07-31 at 17:14 -0700, Andrew Velline wrote:
> When I have a field with memo=3D=E2=80=9Dyes=E2=80=9D in a report, it w=
orks 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.  =20
>=20
> =20
>=20
> I=E2=80=99m using the pre-release 1.3.7 with MySQL
>=20
> =20
>=20
> I=E2=80=99m working around this by COALESCEing a =E2=80=9C=E2=80=9D str=
ing 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.
>=20
> =20
>=20
> Thanks
>=20
> =20
>=20
> =20
>=20
>=20
> -----------------------------------------------------------------------=
--
> 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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________ Rlib-users mailing list=
 Rli...@li... https://lists.sourceforge.net/lists/lis=
tinfo/rlib-users
--=20