asked on

updating data in mysql

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?

SOLUTION

leclairm

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thenone

ASKER

So if I do not have primary keys setup this would cause missing data to being updated in the columns?

leclairm

Actually, forget what I said. Your adding records, not updating them. Sorry, my mistake.

thenone

ASKER

So what could it be?

This only happens when Im moving large amount of data?

thenone

ASKER

My tables are isam tables and not innodb I wonder if this is the case?

leclairm

You could always try using an insert statement directly against your connection that rs1 is using.

Ex:

conn1.execute "insert into table1 (column1,column2) values (" & rs2!column1 & "," & rs2!column2 & ")"

thenone

ASKER

actually the values being inserted are strings.I just find it weird that it only happens when I'm inserting alot of data.

SOLUTION