'NVL' type function

stu9820 · November 18th, 2004, 10:42 PM

Does .NET have an NVL type function. Example:

nvl(variablename, "0")

If variablename doesn't contain a value it gets 0.

Colonel Angus · November 22nd, 2004, 12:19 PM

Is variablename a value returned from a SQL Server database?

If so you can use the function IsNULL(value,replacement value)

- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.

Colonel Angus · November 22nd, 2004, 12:26 PM

Also, you can test variablename for NULL, such as:

If variablename is System.DBNull.value Then
variablename = 0
End If

- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.

stu9820 · November 22nd, 2004, 12:45 PM

It's going into the SQL Server DB. I ended up setting the Default = Null in the stored procedure and it now works.

The problem was that I have a form with 24 possible fields but it's built dynamically based on your search so not all 24 fields are going to be present and thus Null values are coming in when I tried to update the DB. It would give "certain_field does not contain a value" error.