QTP Database conenction and parameterization of the values

[gammaflare]

Get the number of rows in the database and set the number in a variable. Now use a for loop, fetch the first record, put it in the datatable and increment the datatable rowcount ( set datatable(i) where i is the loop counter).

the code should look something like this

NoOfRows = No of rows in the table(this can be done dynamically if the table changes all the time)

Code:

For i = 0 to NoOfRows
     Fetch the Record No i
     Save it in the datatable
     Set Datatable(i+1)
Next