If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > Key Violation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-27-03, 20:22
Ray Holt Ray Holt is offline
Registered User
 
Join Date: Oct 2003
Location: Cleveland, Ohio
Posts: 2
Key Violation

I am an amateur genealogist and I have designed a database project to help me kee track of cemetery listings and I am using Paradox 10. The project consits of two tables. The master table is for listing each of the cemeteries in my files with each cemetery have a unique id number. The second table is a Person Information Table with the information on each person in my files buried in those cemeteries. The Key field in Cemetery ID, the first field in both the Cemetery table and the person information table. My problem is that I have no problem entering info
rmation on the first person, but when I try to enter the information on succeeding persons, using the same Cemetery ID number I get the error message that I have committed a key violation. Can someone help me? Thank you, Ray Holt
Reply With Quote
  #2 (permalink)  
Old 10-29-03, 12:24
Sergey_Pavlov Sergey_Pavlov is offline
Registered User
 
Join Date: Oct 2003
Location: Russia
Posts: 10
Re: Key Violation

Make in the second table 2 key fields - cemeteryID and personID (or PersonName). Combination of this two fields must be unique in the second table otherwise you get key violation. If you have the only key field in the second table - you cen enter only one person for each cemetery.
Reply With Quote
  #3 (permalink)  
Old 10-29-03, 16:44
Ray Holt Ray Holt is offline
Registered User
 
Join Date: Oct 2003
Location: Cleveland, Ohio
Posts: 2
Smile

Thanks. It worked.
Reply With Quote
  #4 (permalink)  
Old 11-08-03, 12:15
sundialsvcs sundialsvcs is offline
Registered User
 
Join Date: Oct 2003
Posts: 706
Thumbs up

"Key violation" simply means that there's already a record in the table with that exact primary-key value. Primary keys must be unique.
...
The message, of course, is "programmer's babble." It made perfect sense to the programmer who wrote it.
__________________
ChimneySweep(R): fast, automatic
table repair at a click of the
mouse! http://www.sundialservices.com
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On