At 07:52 03/11/14 +0000, you wrote:

> >
> > insert into Mytabel select * from Mytabel where MachineID
>= :PMachineID;
> >
>
>This might have worked, except I by this copy ALL fields.
>This give me an error on the primary key and I have to alter 1 other
>field.

You can always use the before insert trigger to alter the primary key value.

>Regards
>Michael
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/