ImportRow Problem

[pendragon]

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