Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

Duplicate records

Jun 13, 2005, 12:53 PM
rdub
User (87 posts)
Jun 13, 2005, 12:53 PM
Post #1 of 10
Views: 6145
Shortcut
Quote Reply
Duplicate records
Is there a mod for DBman to help keep from entering duplicate records?
Jun 13, 2005, 1:18 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 13, 2005, 1:18 PM
Post #2 of 10
Views: 6059
Shortcut
Quote Reply
Re: [rdub] Duplicate records In reply to
The only thing you can do is select one field that you do not want duplicated and make that your key field.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Jun 13, 2005, 1:21 PM
rdub
User (87 posts)
Jun 13, 2005, 1:21 PM
Post #3 of 10
Views: 6077
Shortcut
Quote Reply
Re: [JPDeni] Duplicate records In reply to
So instead of "recordid" I can make "name" the key field and nothing else should be affected?
Jun 13, 2005, 1:28 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 13, 2005, 1:28 PM
Post #4 of 10
Views: 6079
Shortcut
Quote Reply
Re: [rdub] Duplicate records In reply to
You're changing an existing database? I'm not sure what would happen to your "recordid" field in subsequent records. That'll have to be something for you to experiment with.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Jun 13, 2005, 1:43 PM
rdub
User (87 posts)
Jun 13, 2005, 1:43 PM
Post #5 of 10
Views: 6040
Shortcut
Quote Reply
Re: [JPDeni] Duplicate records In reply to
When I changed the key field it put the record number in the name field.
Jun 13, 2005, 1:48 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 13, 2005, 1:48 PM
Post #6 of 10
Views: 6054
Shortcut
Quote Reply
Re: [rdub] Duplicate records In reply to
In your .cfg file, change

$db_key_track = 1;

to

$db_key_track = 0;


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Jun 13, 2005, 1:55 PM
rdub
User (87 posts)
Jun 13, 2005, 1:55 PM
Post #7 of 10
Views: 6043
Shortcut
Quote Reply
Re: [JPDeni] Duplicate records In reply to
Maybe this can't be done. With that change the record number is not tracked and the next number is not entered.
Jun 13, 2005, 1:57 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 13, 2005, 1:57 PM
Post #8 of 10
Views: 6063
Shortcut
Quote Reply
Re: [rdub] Duplicate records In reply to
That's right. There can only be one key.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Jun 13, 2005, 2:01 PM
rdub
User (87 posts)
Jun 13, 2005, 2:01 PM
Post #9 of 10
Views: 6052
Shortcut
Quote Reply
Re: [JPDeni] Duplicate records In reply to
Once you get around 100 records how do you keep track of possible duplicates? Or don't you?
Jun 13, 2005, 2:07 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 13, 2005, 2:07 PM
Post #10 of 10
Views: 6033
Shortcut
Quote Reply
Re: [rdub] Duplicate records In reply to
Most times it's not an issue. You could do a search before adding a new record if you're not sure whether one like that has been added already. It doesn't take that much time.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.