Integrity constraint violation error messages.
Posted: Thu Jul 10, 2008 3:00 pm
This is my first post to this forum so please bear with me as I am a new Open Office user and not a database expert by any means.
Maybe 15 years ago I managed to learn the DOS version of Paradox well enough to design a relational database to hold my book company customer information and print out invoices. I linked four tables: Addresses, Orders, Books and Mailings. Although it was a DOS program, Paradox migrated and worked well for me through Windows 3.1, 95 and XP. I knew I'd have to give it up some day but the idea of learning a new Windows database program put me off. Then recently I decided it was time to update my 6 year old XP desktop and bought a new PC with Vista which does not support DOS programs. I have several DOS programs which I love that have travelled with me over the years and the fact that Vista is not backwards compatible is very frustrating to me but that's another problem.
In my attempt to bring my Paradox tables into the new Windows Vista environment, I decided to try Open Office Base, but I am not having much success. After exporting the Paradox tables to .dbf files and copying and pasting them into Base Open Document File format, I can then edit each table independently, but when I try to link them with tools/relationships, I begin getting all kinds of error messages. One I see frequently is "Error entering new record. Interity Constraint Violation - no parent SYS_FK_269 table:" followed by a string of code. So I tried starting from scratch by designing each table with the same names and rows and columns as the originals but empty of data. Then I used tools/relationships to link them together as they were in Paradox. Up to this point things seem to work fine until I start entering data in the tables. Then I start to get those error messages again. Unlinking them, I can enter data fine, but as soon as they are linked, no can do.
Is there anywhere I can get details about what these error messages mean and how to correct my relationship linking problems? All the Open Office help files and user manuals I've seen so far seem to be very basic compared to the volumes of detailed information available to non experts like me to figure out Paradox.
Maybe 15 years ago I managed to learn the DOS version of Paradox well enough to design a relational database to hold my book company customer information and print out invoices. I linked four tables: Addresses, Orders, Books and Mailings. Although it was a DOS program, Paradox migrated and worked well for me through Windows 3.1, 95 and XP. I knew I'd have to give it up some day but the idea of learning a new Windows database program put me off. Then recently I decided it was time to update my 6 year old XP desktop and bought a new PC with Vista which does not support DOS programs. I have several DOS programs which I love that have travelled with me over the years and the fact that Vista is not backwards compatible is very frustrating to me but that's another problem.
In my attempt to bring my Paradox tables into the new Windows Vista environment, I decided to try Open Office Base, but I am not having much success. After exporting the Paradox tables to .dbf files and copying and pasting them into Base Open Document File format, I can then edit each table independently, but when I try to link them with tools/relationships, I begin getting all kinds of error messages. One I see frequently is "Error entering new record. Interity Constraint Violation - no parent SYS_FK_269 table:" followed by a string of code. So I tried starting from scratch by designing each table with the same names and rows and columns as the originals but empty of data. Then I used tools/relationships to link them together as they were in Paradox. Up to this point things seem to work fine until I start entering data in the tables. Then I start to get those error messages again. Unlinking them, I can enter data fine, but as soon as they are linked, no can do.
Is there anywhere I can get details about what these error messages mean and how to correct my relationship linking problems? All the Open Office help files and user manuals I've seen so far seem to be very basic compared to the volumes of detailed information available to non experts like me to figure out Paradox.