View Single Post
  #1 (permalink)  
Old July 19th, 2003, 03:10 AM
rachelow rachelow is offline
Registered User
Join Date: Jul 2003
Location: San Francisco, CA, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default copying array to table (reverse of getrows?)

Does anyone know if there is a method for taking the rows in an array and copying them back into a recordset?

I want to extract rows from a recordset into an array, run some calculations, and then put the results into a third table for storage.

I don't want to lose the original values, so I would not want to update the underlying recordset.

One more thing...If I want to use Access as the database, does this mean that the cursortype must be static? I read something that said Access cursors are on the client, and clientside cursors are always static. Just trying to verify if this is true.

Any ideas/comments on this would be much appreciated. Thanks in advance for your help!