Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
| Search | Today's Posts | Mark Forums Read
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2003, 03:10 AM
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!


Rachel




Similar Threads
Thread Thread Starter Forum Replies Last Post
copying values into a column from another table madrob3975 SQL Server 2000 1 December 8th, 2006 03:31 AM
Copying from one table to another Clive Astley VB Databases Basics 2 August 23rd, 2005 12:48 AM
copying from table 1 inserting in table 2 gilgalbiblewheel Java GUI 0 September 15th, 2004 03:40 PM
getrows method-urgent????? mikedeepak Classic ASP Databases 6 September 1st, 2004 03:36 AM
Copying Table Relationship Diagram mike123abc SQL Server 2000 1 February 19th, 2004 09:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.