Recordset Query/save DAO 
Author Message
 Recordset Query/save DAO

Though I've programmed VB for years, I've never used it for a serious
Database App.  I've used Foxpro where you have cursors instead of
recordsets and can use the cursors almost like tables.  Cursors
allowed multiple select statements while keeping data in memory, not
having to write data to a file, for example:

    Select (fields) from (tablename) where (criteria) into cursor Temp


    Select (fields) from temp where (new criteria) into cursor NewTemp

etc,  eventually being able to save the data to a file by

    Select * from (TempCursor) to table (Saved _Data)

My questions:

        With VB DAO is there a way to query a recordset like in the

        If not, is there any way to save a recordset to a table?

Thanks in advance.

Richard E Barlow
Shoal Creek Software

Wed, 08 Sep 2004 10:53:34 GMT  
 [ 1 post ] 

 Relevant Pages 

1. SQL queries or DAO recordset?

2. Query on dao recordset (ACC97)

3. Using DAO to open pre-defined Access queries - returned recordset bad

4. Assigning a Dao.Recordset to a Datacontrol With VB6 SP4 and Dao.360

5. DAO Recordset.LastUpdated in DAO

6. Query from Query - How in VB6 - DAO????

7. recordset a query of a recordset?

8. Recordset as query result of recordset, possible?

9. querying a query(recordset object) [ADO]

10. Query Recordset, Create Summary/New Recordset

11. querying a query(recordset object) [ADO]

12. query a query recordset?


Powered by phpBB® Forum Software