Article View: borland.public.cppbuilder.database.multi-tier
Article #321Re: Key violation
From: John Graham
Date: Sun, 13 Jan 2002 16:15
Date: Sun, 13 Jan 2002 16:15
12 lines
1479 bytes
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.
Technical Details
Message-ID:
<3C41B284.E9F6215E@salts.navy.mil>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnewsReferences:
<3c3d4016_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,a0cb54d31e2fdd56 X-Google-Attributes: gidfcd2b,public X-Google-ArrivalTime: 2002-01-13 08:29:20 PST Message-ID: <3C41B284.E9F6215E@salts.navy.mil> Date: Sun, 13 Jan 2002 11:15:00 -0500 From: John Graham <jgraham@salts.navy.mil> X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Re: Key violation References: <3c3d4016_1@dnews> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 163.12.6.12 X-Trace: dnews 1010938493 163.12.6.12 (13 Jan 2002 08:14:53 -0800) Lines: 13 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews