troubleshooting Question

updating data in mysql

Avatar of thenone
thenone asked on
Visual Basic Classic
9 Comments3 Solutions210 ViewsLast Modified:
I've noticed in my project when I move records from one table to another escpecially a large amount of data I lose some data in the fields and they are not blank.When I move a smaller portion of data everything gets moved over good.I'm updating like this

with rs1.addnew
!column1 = rs2.Column2
!column2 = rs2.column2
.update


is there something that I am missing?
ASKER CERTIFIED SOLUTION
pradapkumar

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros