Move the data first and then apply the foreign key afterwards.

This is assuming the data is correct.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Stan Smeets" <s.smeets@...>
To: <IBObjects@egroups.com>
Sent: Friday, November 24, 2000 3:21 AM
Subject: [IBO] conversion to interbase foreign key constraint violation


> hello all
>
> I am trying to convert some tables to interbase using TIBOTables
> The test database is like this
> table Aktesrt with fields code(numeric) and description
> table Zaaksrt with fields code(numeric) and description
> table Zaak with fields Doosnr(numeric), zaaknr(numeric),
> aktesrt(numeric+foreignkey) and zaaksrt(numeric+foreignkey)
>
> Because I also want to test the speed for the conversion I am
> converting a table with about 80,000 records
>
> While trying to run the conversion The first 3220 records run fine
> then I get the following message on
> dmibconv.IBOTzaak.ApplyUpdates
>
> ISC ERROR CODE:335544466
>
> ISC ERROR MESSAGE:
> violation of FOREIGN KEY constraint "FK_ZAAKZAAKSRT" on table 'ZAAK"
>
> I cannot undestand this message becouse when I trace
> what is going on I get a zaaksrt number that exists
>
> what am I missing?
>
>
>
>
>