Recent changes to DB null handling?

Peter Illes · Post by **Peter Illes** » Thu Aug 02, 2007 6:51 pm

Hi,

It seems to me that there might be a newly introduced bug in 2007.2 / recent versions (I see this with the latest): when a field is null, things used to work, but now I get strange errors like get_XXXX cannot cast DBNull, and when I pass the column to a function (my Lookup()) then the function is not called at all if the column is null, instead that part is aborted (there must be a silent exception lurking in there).

Any ideas?

TIA,
Peter

Post by **Vital** » Sun Aug 05, 2007 12:47 am

Please provide more details for this error (full error stack, report, report code).

Thank you.

Peter Illes · Post by **Peter Illes** » Mon Aug 06, 2007 12:40 pm

Vital,

I have a Text control with the following Text value:

Code: Select all

{ "Country:" + Lookup(PARTNER2.BILLINGCOUNTRY_ID, COUNTRY, "DESCRIPTION") }

Now if PARTNER2.BILLINGCOUNTRY_ID is null, then Lookup() will not be called, and the whole control will be empty. This used be OK (Lookup() handles nulls inside).

TIA,
Peter

Post by **Edward** » Tue Aug 07, 2007 4:06 am

Is the HideZeroes property of the Text component set in true? Please check it.

Thank you.

Peter Illes · Post by **Peter Illes** » Fri Aug 10, 2007 4:26 am

Edward: no, HideZeroes == false.

Post by **Vital** » Fri Aug 10, 2007 4:51 am

Report with sample data possible?