I specified a query manually for a database output value for which during runtime it should return 7 rows,
I am outputting the values in to Global data table, now for each iteration of my script I want to use each rows value, so I parameterized all the values to 1 column in the global data table say division number (column name), But during runtime(in the runtime datatable) what is happening is I am seeing only 1 row value that is the last one among the 7 division numbers,
can anybody help me as to why it is coming up like that ?
I created a function and looping using while not rs.eof,
even in the function recordset is moving as desired,but every iteration I gave datatable.setnewrow but don't know why always the value is getting placed in first row only, cursor is not moving to next row in the global datatable, any help is appreciated.