| || |
Here is my scenario
I am trying to capture VALues from DB and then validate if the values in DB are right.
1)First sql i use is get values of names Set ObjM conn1.Execute(sqlcheck_Approx)
I use ObjM to capture the values of name
2) Second sql I use is to gather how many rows are there
in the Result or count
Set Number_007 = conn1.Execute(Sql_Count)
Now I try to print using the loop
For i=0 To Number_007(0)
" I get the mismatch ERROR at the line For i=0 To Number_007(0).
I Try the second option ivalue = Number_007(0)and
For i=0 To ivalue
I get the mismatch error for line >> For i=0 To ivalue.
Your advice for other options are welcome.
My final goal is to capture list of names from sql and validate if the specific names exist in them.
Re: type mismatch
Give Cint(Number_007(0)) & check