View Single Post
  #1 (permalink)  
Old February 21st, 2004, 02:32 AM
eapsokha eapsokha is offline
Authorized User
Join Date: Nov 2003
Location: Phnom Penh, , Cambodia.
Posts: 44
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to eapsokha
Default Reuse the recordset object

I want to a recordset object at least twice times; first for students, second for teacher and third for subjects as below:

objRecordset.Open "SELECT * FROM tbl_student", objConn
'list of students
objRecordset.Open "SELECT * FROM tbl_teacher", objConn
'list of teachers
objRecordset.Open "SELECT * FROM tbl_subject", objConn
'list of subjects

I may reuse the recordset of students in here too.

Can I do that? if so, how?

Many thanks

Mr. Sokha Eap
UNDP Cambodia