>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?
Is this your actual code? It's hard to tell what you're doing here. First off, I'd make sure you're using a different ALIAS for the table you're INSERTing into (assuming it's different from the one you're SCANning).
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up