ADO : Using multiple recordsets

[Karl Blessing]

For access databases I had to use OpenSchema to get all the tables, but now I want to modify the recordset so that I only get back TABLE_NAME, DATE_CREATED, DATE_MODIFIED in that order, I was wondering if it may be possible to create a second recordset from the first one, only queried so that it only grabs the content out of the original Recordset, this is the line I use to get the original set<br><FONT FACE=monospace><br>Conn.Open Request.Form(&quot;Path&quot, &quot;sa&quot;, &quot;&quot;<br>set RS = Conn.OpenSchema(20, Array(Empty, Empty, Empty, &quot;TABLE&quot)<br></font><br>20 is adSchemaTables<br>and as you can see I already managed to figure out how to get it to only return &quot;Table&quot; types for one of the Field<br><br>any clue?<br> <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[Asif]

Kb244,<br><br>Have you ever tried &quot;NextRecordset&quot; method of ADO object. This will provide you next recordset from one created Open command for multiple tables.<br>

 

[Karl Blessing]

I think you missed my point, I need some method of querying a existing recordset into a new one, for example above, I want to take all TABLE_NAME, DATE_CREATED, DATA_MODIFIED in that order, into the new recordset, I tried to find NextRecordset or OpenRecordset, didnt find it, that in the connection object? <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[TRYP]

hey karl couldnt you create a table with the result of your first recordet and then query it. then use an if 2 dates 1 not a date to get the table name. the modified has to be equal or greater than the created date. follow my logic ??
-tryp

 

[Karl Blessing]

very old topic, but it has been fixed, i cant remeber how I fixed it, since this is quite old.
Karl
kb244@kb244.com

http://www.kb244.com

Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)

http://www.brainbench.com/transcript.jsp?pid=629151