infinite recordset?

[Goh]

can recordset be used as many as possiblewithin a conn to refine the display of data?

[Dalceon]

I'll be the first to say

Whhhaaaaaaa???

please restate the question.

[Goh]

i got an example :


First have 2 Label controls one with Index as 0.

Private sub Btn_Click()
rs1=select distinct(col 1) from table
do until rs1.eof
rs2=select (col 2) from table where (col 1) = rs1(0)
--clear all arrays of label2
if Not rs2.eof then
intLoad=Label2.ubound
load label2(ubound) and set the visible=true and top=(value)
label1.caption=rs1(col 1)
label2(ubound).caption=rs2(col 2)
end if
rs2.close
rs1.movenext
loop
rs1.close
End Sub


which i dunn really understand....clearly..and if the table is taken from a join tables ie rs1,rs2,rs3..is it ok?if you understand the 'code' pls elaborste thanks

[leinad31]

I explained what was intended with that code in your other thread... you shouldn' create so many threads if they are related anyway... its difficult to keep track of the topics that come up during discussion of the original topic.

[Goh]

sorrie....cuz i dun really understand the code well..and desperately want to achieve the goal....(my boss is pushing me...