Key violation

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Bill Thu, 10 Jan 2002 07:15

#318

Author: Bill
Date: Thu, 10 Jan 2002 07:15

3 lines
1036 bytes

When I insert a record and ApplyUpdates the Master/Detail from the client,
it works well. But I ApplyUpdates the second time, an error occured:cann't
insert repeated primary key. Why.

Re: Key violation

#321

Author: John Graham
Date: Sun, 13 Jan 2002 16:15

12 lines
1479 bytes

Because database management systems will not allow duplicate primary keys.
The primary key must be unique otherwise what good would it be?  If you need
this key to be duplicated, you need to designate another key field to be your
primary.  An example of a primary key field would be "Customer_ID".  It
wouldn't make sense to have the same ID represent two different customers.
John

Bill wrote:

> When I insert a record and ApplyUpdates the Master/Detail from the client,
> it works well. But I ApplyUpdates the second time, an error occured:cann't
> insert repeated primary key. Why.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads