Handle Null value in QTP
I am using MS -Access for TestData, while retreving the data,when the database column value is null, i am getting null value from database. when i try to set a null value in a field, I am getting error. is there any function in QTP to restrict Null.
Thanks in advance
Re: Handle Null value in QTP
You could check for the null using the IsNull function, which will return a boolean - then assign a more relevant value to the field if a Null appears in the database.
<font class="small">Code:</font><hr /><pre>
If IsNull(dbField) Then
controlvalue = <whatever you need it to be>