Subject | conversion to interbase foreign key constraint violation |
---|---|
Author | Stan Smeets |
Post date | 2000-11-24T10:21:48Z |
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?
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?