Using SQL Against Resultset
Does anybody know if I can open a resultset and have a resultset as a data
source? For example:
I open first resultset as
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.CursorLocation = adUseClient
rs.Open "SELECT * from psivert;"
Then I would like to create a second resultset against rs that was just created.If
this is possible can I see the code sample
The reason I need to open a second recordset against first recordset is described
below. If there are any other ideas on how to handle it please let me know.
I have to write an application that needs to recalculate spread
control on the screen at the same speed Excel does it(immediately), save
changes to the local Access 97 database and
refresh a second screen(2 screen has to be open at the same time)
to reflect changes from the first screen. First screen is a
detail level screen and 2nd screen is a summary screen.
If I can do all changes against resultsets in memory instead of DB it should
be much faster(I think). Also in order to
do what I need to do I should be able to run different SQL functions against
resultset in memory(sum, group by etc). Then
at predetermined time intervals I will save these resultsetsets
to the Access DB.
Thanks for any suggestions
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL