I want to know the use of recordset..whhy do we use it?
What is the difference between recordset and connection... when both are used to fetch the values for database?
I have written this code:
Set con = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
rs.Open "select count(*) as rownum from [tbl_cond$]",con
row_num = trim(rs.Fields("rownum"))
rs.Open "select * from [tbl_cond$]",con
For i = 0 to row_num-1
It works for rs(0) but why doesn't it works for rs(1)
Connection - Saying hello with help of driver
Recordset - keeping valuables in basket to use/modify it by running query in that basket