GetRows. Where is PutRows (1 Viewer)

Soton

Registered User.
Local time
Today, 06:48
Joined
Mar 17, 2008
Messages
17
GetRows can be used to extract a recordset to an Array for processing quickly using code. Is there an equivalent to put the values from an array back into a table using a single one-line statement rather than working through each record and field individually. This can be a pain if there are 20 or 30 fields.
 

MarkK

bit cruncher
Local time
Yesterday, 22:48
Joined
Mar 17, 2004
Messages
8,179
When you dump data from a recordset to an array you destroy information about the source table, datatypes, ordinal positions, column names, and so on. If PutRows existed it would have to re-create all that information and in that case it would look almost exactly like OpenRecordset or INSERT INTO.
 

Users who are viewing this thread

Top Bottom