Handle a null value
Posted: Thu Oct 24, 2024 3:45 pm
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
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