Check for nulls

[asrinath]

Hello All,

I want to check for the existence of nulls in a database column and display Not Found if it is null. How do I do that using Actuate programming?

TIA

 

[bcaslow]

Use the IsNull( ) function. If this is for a text control, you could do this on the DataRow's OnRead( ) method:

If IsNull(ColumnA) Then
ColumnA = "Not Found"
End If

Or, you could use the IIF expression in the control's ValueExp expression:

IIF(IsNull(ColumnA), "Not Found", ColumnA)