I need some wisdom from some of you fine people. I am confused about IsNull and how an If statement is working.
1. the DB is SQL Server 2000
2. i only have read access on the Table
2. the Column in the Table is System__bUser__bID, vchar, 256, allow nulls
If the value in System__bUser__bID is "Vault" I am to bypass the record otherwise I am to check the next selection field.
The code:
IF ((rsCommon("System__bUser__bID")) <> "Vault")
IF "next field" bla bla bla.....
This works like a champ....UNTIL....rsCommon("System__bUser__bID")) is Null. If it is Null then the field is treated as it is equal "Vault" hence my heightened ignorance. If i add "OR IsNull(rsCommon("System__bUser__bID")) = True" then it works like a champ again.
I just don't understand how Null equals Vault. Any guidance is welcome.
Topic Options
Post Options
Thanks(0)
