How to insert NULL Value??
HI, I am checking Mandatory information whether its messing or not, so from Excel i want to input NULL value in my Text Field, while execution it prompts for Type Mismatch as it expecting a tex...
Forum Discussion
Just a quick follow up to this, its kind of in the same area i'm having an issue,
Im new to testcomplet and I have a CSV file where it is in a loop and in different rows, different fields are empty.
so far as
1. first name, last name, middle name, address -- all are populated the first time
2. first name, last name, middle name, address -- first is blank value
3. first name, last name, middle name, address -- last is blank value
4. first name, last name, middle name, address -- address is a blank value.
and in the loop it runs through each row and I'm trying to get it to insert the null value into the field and save the new entry.
I keep getting type mismatch and cannot figure out how to get around it or to have the loop remove the values on each one. I just need to see if its possible to do it without having to have the script on each iteration delete that field entry after.
is this possible?
Im new to testcomplet and I have a CSV file where it is in a loop and in different rows, different fields are empty.
so far as
1. first name, last name, middle name, address -- all are populated the first time
2. first name, last name, middle name, address -- first is blank value
3. first name, last name, middle name, address -- last is blank value
4. first name, last name, middle name, address -- address is a blank value.
and in the loop it runs through each row and I'm trying to get it to insert the null value into the field and save the new entry.
I keep getting type mismatch and cannot figure out how to get around it or to have the loop remove the values on each one. I just need to see if its possible to do it without having to have the script on each iteration delete that field entry after.
is this possible?
