Hello and thanks for reading and probably also helping me
A brief explanation of my problem:
I copy data from one Firebird database to another (called V14), and I use IBExpert for this. Tables are called the same and have the same structure. For explanation, I'm going to call a table containing data in the old database A and the table into which I want to insert the data will be called B.
So, the only thing to do is to take all the data from table A and paste it into table B. A small piece of code for this:
INSERT into [V14].BSMZ SELECT * FROM BSMZ
When doing this, I get an error message (after wrapping some lines):
Invalid insert or update values: object columns are limited — there are no two rows in the table that may have duplicate column values. try to keep the duplicate value (visible for active transactions) in the unique index "UI_BSMZ"
This unique index contains 2 columns of data and applies to tables B and A.
There are several lines that cause this problem, but several lines are also transmitted as desired. I argued that rows that cannot be inserted into table B have values in their unique key codes that are not found in table B.
(For testing, I removed the restriction from table B. But I still get the same error message, which bothers me even more)
I'm not quite sure what might cause this problem, and some tips will be appreciated.