Handling Executed Queries

Hey All,

I'm writing a VB App at the moment on a bit of a learning curve for my own benefit and have made a Mock Up Database and used the "DataEnviroment" to connect to it. I have done this all find and used the SQL Builder to make a query on the database and that worked great!

One problem reside's.

How can I get it so I can store the retrieved information to a variable or be written to another source? I know this is definately not one for the pros, and mock me if you like but it is of great inportence to find this out.

Thankyou in advance for any help that is given,

Jester

I think what you need is recordsets. Check out some ADO tutorials, MSDN help and the database section on this forum to learn more about it.

.

Following should help you. Once the query is performed then get the results as follows:

VB Code:

Sub Selected(qdfTemp As QueryDef)
 
   Dim rsTemp As Recordset
   
Set rsTemp = qdfTemp.OpenRecordset(dbOpenForwardOnly)
   
   'Enumerate recordset for found records
   With rsTemp
   
      Do While Not .EOF
      
         'Get Values and assign to variables
 
         lngYourVariable = !fldName         'Used in Your SELECT
 
        .MoveNext
      Loop
  
   End With
  
   rsTemp.Close
   Set rsTemp = Nothing
   
End Sub

Thanks for replying, it means heaps!

I will try all of your advice (I have already downloaded a tonne of help files from MSDN as I haven't got a copy of the CD :( .

I am still going in to working with Database's with a bit of a blind eye so I still haven't learnt what I need to learn on Recordsets but I've always been a quick learner.

Any on-going advice will be greatly appreciated.

Jester.:)