VBcoders Guest



Don't have an account yet? Register
 


Forgot Password?



To Validate Database Null Values

by Raghuraja. C (21 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Thu 17th February 2005
Date Added: Mon 8th February 2021
Rating: (1 Votes)

To Validate Database Null Values

Rate To Validate Database Null Values



    'To validate NULL value
    On Error GoTo LOCALERRORHANDLER
    If IsNull(strPVAL) Then
        fnNULL = ""
    Else
        If IsNumeric(strPVAL) Then
            fnNULL = strPVAL
        Else
            If strPVAL <> "" Then
                fnNULL = Replace(strPVAL, " ", " ")
            End If
        End If
    End If
    Exit Function
LOCALERRORHANDLER:
    fnNULL = ""
End Function

Download this snippet    Add to My Saved Code

To Validate Database Null Values Comments

No comments have been posted about To Validate Database Null Values. Why not be the first to post a comment about To Validate Database Null Values.

Post your comment

Subject:
Message:
0/1000 characters