onebite2
asked on
Dealing a Short datatype in VB.net
I have a field called(year built) with short data type ,need to validate that field with couple of validations how to that for 3 clauses??
1.Value should be equal to 9899 or be equal to or greater than '1600' and less than current date
Below is the code I have need to add these clauses :
Private Sub YEARBUILT(ByVal Row As Input0Buffer)
ColumnName = "YEAR_BUILT"
If Row.inYEARBUILT_IsNull = True Then
Row.outYEARBUILT_IsNull = True
ElseIf Row.inYEARBUILT = 0 Then
Row.outYEARBUILT_IsNull = True
Else
Row.outYEARBUILT = Row.inYEARBUILT
End If
End Sub
1.Value should be equal to 9899 or be equal to or greater than '1600' and less than current date
Below is the code I have need to add these clauses :
Private Sub YEARBUILT(ByVal Row As Input0Buffer)
ColumnName = "YEAR_BUILT"
If Row.inYEARBUILT_IsNull = True Then
Row.outYEARBUILT_IsNull = True
ElseIf Row.inYEARBUILT = 0 Then
Row.outYEARBUILT_IsNull = True
Else
Row.outYEARBUILT = Row.inYEARBUILT
End If
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.