Re: dupe records on refresh

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 12:35:26 -0500

2obvious wrote:
> Despite my best efforts, I cannot prevent bogus duplicate records in
> my database. I

Preventing duplicates is what your database's primary key and/or unique
index is for. It is folly to attempt to use application code to do your
database's job. Your database should be designed to protect your data's
integrity. Given that you're telling us that duplicates are being allowed, I
can pretty much guarantee that your database design is flawed.

Post some details and maybe somebody will have some suggestions.

Bob Barrows 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: Switching from Corel Paradox to Access 2010
    ... Our current database system uses a central customer database, ... I mean that the script would compare the customer info fields ... clusters which are compared with other clusters to eliminate duplicates. ... ' Build a sort string to make sure duplicate records are ...
    (microsoft.public.access.modulesdaovba)
  • Re: Getting duplicates but I dont know why
    ... >understand why I am getting duplicates. ... ate Sub TriageAndApply(InRecordset As ADODB.Recordset, ... >Our program reads records from the first database and then attempts to ... If a record is not found in the second database, ...
    (microsoft.public.vb.database.ado)
  • Re: Help writing SQL statement in PHP script
    ... IMPOSSIBLE to determine if the database is normalized or not from the ... normalized - AND STILL HAVE DUPLICATES IN THESE COLUMNS. ... It would be nice if you knew something about database normalization ... There is nothing flawed about a design which has three ...
    (comp.lang.php)
  • Re: Reading large csv-file and removing duplicates
    ... of course make that amount memory available to it (even if it is virtual ... Then you can remove duplicates from each ... using the hard disk as a temporary storage to classify the data as you are ... data into a database, and then let the database do the work of sorting out ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Help writing SQL statement in PHP script
    ... IMPOSSIBLE to determine if the database is normalized or not from the ... normalized - AND STILL HAVE DUPLICATES IN THESE COLUMNS. ... I've been doing database normalization for over 20 years. ... The correct query works in this case just fine. ...
    (comp.lang.php)