Forum Discussion

testcmpleteuser's avatar
testcmpleteuser
Occasional Contributor
9 years ago
Solved

Sending error message to log reading SQL

I have a scenario in my test where I need to make sure that the field A in a table doesnt save as null. If it does, I want to send an error message to the log. But although, one field is null in my r...
  • HKosova's avatar
    HKosova
    9 years ago

    You probably need to use the IsNull function:

    If IsNull(acttest.fields("onefieldA").value) Then
 ...

     Of you may need to compare with Nothing:

    If Not acttest.fields("onefieldA").value Is Nothing Then
 ...

    See also: Nothing vs Empty vs Null

NisHera's avatar
NisHera
Valued Contributor
9 years ago

in VB scripting comparison operator is "= =" you have used "="

try if acttest.fields("onefieldA").value == null