Page 1 of 1

Recent changes to DB null handling?

Posted: Thu Aug 02, 2007 6:51 pm
by Peter Illes
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

Recent changes to DB null handling?

Posted: Sun Aug 05, 2007 12:47 am
by Vital
Please provide more details for this error (full error stack, report, report code).

Thank you.

Recent changes to DB null handling?

Posted: Mon Aug 06, 2007 12:40 pm
by Peter Illes
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

Recent changes to DB null handling?

Posted: Tue Aug 07, 2007 4:06 am
by Edward
Is the HideZeroes property of the Text component set in true? Please check it.

Thank you.

Recent changes to DB null handling?

Posted: Fri Aug 10, 2007 4:26 am
by Peter Illes
Edward: no, HideZeroes == false.

Recent changes to DB null handling?

Posted: Fri Aug 10, 2007 4:51 am
by Vital
Report with sample data possible?