I would like to copy a set of records but change the key when
inserting them.

select employee
scan for employee.empid=1234
  insert into employee(empid,task);
     values (NewEmpId,employee.task)
endscan

I can't make this work. It appears to get stuck in a loop.
What am I doing wrong?