Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Violation of PRIMARY or UNIQUE KEY



Permlink Replies: 1 - Last Post: Nov 10, 2016 10:32 AM Last Post By: John MacDonald Threads: [ Previous | Next ]
John MacDonald

Posts: 179
Registered: 3/22/98
Violation of PRIMARY or UNIQUE KEY
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 10, 2016 8:21 AM
Hello All:

I'm using Interbase and I've learned that each of my tables is much better off once I establish a primary key.

Now with that said, I have a master table that is linked to details in sub queries. I can edit the details no problem, but now I started to get this error.

Each of the detail tables has a primary key. This helps when editing.

If I jump in and edit more than one record in the detail table, then I get this error during my apply updates.

I will continue to work on this.

I am using Interbase and FireDac.

John

--
JMAC out

John MacDonald

Posts: 179
Registered: 3/22/98
Re: Violation of PRIMARY or UNIQUE KEY
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 10, 2016 10:32 AM   in response to: John MacDonald in response to: John MacDonald
The tables in question are quite simple and this sample is small.
I dropped the tables and recreated them. Now they are functioning properly.....?
The error had something to do with the primary key having an issue. I hope this does not re-occur.

Admittedly, I am new to this, I did not identify the primary id right away.

John

John MacDonald wrote:
Hello All:

I'm using Interbase and I've learned that each of my tables is much better off once I establish a primary key.

Now with that said, I have a master table that is linked to details in sub queries. I can edit the details no problem, but now I started to get this error.

Each of the detail tables has a primary key. This helps when editing.

If I jump in and edit more than one record in the detail table, then I get this error during my apply updates.

I will continue to work on this.

I am using Interbase and FireDac.

John

--
JMAC out


--
JMAC out
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02