pendragon
Well-known member
Hi
I am copying records from one table to another using the ImportRow command, this works ok but when I tried to add the records to the database nothing happened, This I believe is due to the fact that ImportRow copies all the state information into the new table so Insert does not think it has anything to do.
I can live with that as I have to set a flag on each record to say where it came from.
The problem is when I call my insert records routine it thinks that it has to run an UPDATE command and not an INSERT command so I get the error Update requires a valid update command.
Does anyone know how to get over this apart from doing it the long way by adding a newrow and setting each column individually?, which works but I have 7 tables to copy from and was hoping to do it in a single routine.
Thanks
I am copying records from one table to another using the ImportRow command, this works ok but when I tried to add the records to the database nothing happened, This I believe is due to the fact that ImportRow copies all the state information into the new table so Insert does not think it has anything to do.
I can live with that as I have to set a flag on each record to say where it came from.
The problem is when I call my insert records routine it thinks that it has to run an UPDATE command and not an INSERT command so I get the error Update requires a valid update command.
Does anyone know how to get over this apart from doing it the long way by adding a newrow and setting each column individually?, which works but I have 7 tables to copy from and was hoping to do it in a single routine.
Thanks