Bill Katelis wrote:

> how about:
> delete the one you are copying to and then insert into.
>
> eg.
> delete from Mytabel where MachineID = ...;
>
> insert into Mytabel select * from Mytabel where MachineID = :PMachineID;

He couldn't do that, since it would make a PK violation. MachineID is a
PK for that table.

--
Milan Babuskov
http://fbexport.sourceforge.net