Page 1 of 1

Handle a null value

Posted: Thu Oct 24, 2024 3:45 pm
by skymvm
Hi
I have a field in my database with nvarchar type that contains null, I can't manage it, I used iif like this
{iif(DataSource1.field1== null,DataSource1.field2, DataSource1.field1)} and this b
IF (DataSource1.field1== null)
DataSource1.field1.value "1"
Else
DataSource1.field1.value "DataSource1.field1"
End If
but they didn't work and I couldn't fix that, I would be appreciate if you could help me

Re: Handle a null value

Posted: Fri Oct 25, 2024 7:34 am
by Lech Kulikowski
Hello,

What product and version are you use?

Thank you.

Re: Handle a null value

Posted: Sat Oct 26, 2024 4:47 am
by skymvm
I realized what my problem is
I've asked another question
Thank you

Re: Handle a null value

Posted: Mon Oct 28, 2024 4:41 am
by Lech Kulikowski
Hello,

Ok.