--- In firebird-support@yahoogroups.com, "leugim@..." <leugim@...> wrote:

>
> Hello,
> On one of our client server where I did an upgrade from Fb1.5 to Fb2 I
> had the the following problem when executing a query (this copy about
> 5e6 of records from table ATABLE to an archive table ATABLE_20060701):
>
> insert into ATABLE_20060701 select * from ATABLE where ATime <

'2006-07-01';

My guess is that the field order is mixed. Have you tried to
explicitly name each field in your statement.

insert into ATABLE_20060701 (field1, field2) select field1, field2
from ATABLE where ATime < '2006-07-01';

Adam