J
JimS
I have a subset of records I want to "clone" into the same table. Originally,
I did it with SQL, and that worked fine, but I've had to change some of the
fields and the SQL is becoming confusing for anyone else who follows to
understand, so I'm doing it with a pair of ADO recordsets...
Initially, what I want to do is copy EVERY field from each record in the one
recordset (rst2) into the new record in the other recordset (rst1). Ideally,
I should be able to code something like
while not rst2.eof
rst1.addnew
rst1.everyfield=rst2.everyfield ' This is the property I don't
know.....
...etc...
rst1.update
rst2.movenext
end while
Is there a property like "everyfield", or must I exlicitly assign every
field...(for each...)
I did it with SQL, and that worked fine, but I've had to change some of the
fields and the SQL is becoming confusing for anyone else who follows to
understand, so I'm doing it with a pair of ADO recordsets...
Initially, what I want to do is copy EVERY field from each record in the one
recordset (rst2) into the new record in the other recordset (rst1). Ideally,
I should be able to code something like
while not rst2.eof
rst1.addnew
rst1.everyfield=rst2.everyfield ' This is the property I don't
know.....
...etc...
rst1.update
rst2.movenext
end while
Is there a property like "everyfield", or must I exlicitly assign every
field...(for each...)