Re: Insert with response

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 11/07/04 

Date: Mon, 08 Nov 2004 00:41:54 +0100

On Sun, 7 Nov 2004 15:29:13 -0600, Louis Davidson wrote:

>> I can't speak for Louis, but I'll tell you that this WILL work. In fact,
>
>True :)
>
>> it will even work when the same applicant tries to register again - if you
>> defaine only an identify column and nothing else as PRIMARY KEY or UNIQUE,
>> you'll never have duplicate key violations again - not even if you really
>> should have them.
>
>The lack of error messages does not mean that it works. The rest of your
>post seems to contradict this point.

Hi Louis,

If you'd seen my face when I wrote this message, you'd have known that the
"it will work" remark was sarcastic - I tried to put across the point that
this design will "work" (i.e. accept entered data) even when it soould not
"work" (i.e. it should reject the data for being duplicate data).

> Identities have limitations which should be understood, but they
>work very nicely as surrogate keys.

My point exacly. Unfortunately, the world is still littered with a
depressingly large population of database designers who will just happily
stick an identity column on a semi-random collection of columns and think
that they now have a good design. <sigh>

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • Re: Relationship question
    ... the design as a separate identity. ... CONTACTS_ID (Primary Key - Autonumber) ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Dynamic column specification in table update
    ... Pro SQL Server 2000 Database Design - ... > primary key should be made up from your data. ... >> The only excuses tend to fall along the lines of laziness or ignorance. ...
    (microsoft.public.sqlserver.programming)
  • Re: Dbase3 Conversion
    ... If you mean that it can sort easily through the interface, ... happens in the table design view. ... Primary Key, it makes an index to implement that. ... though I haven't seen dbase in so long that I ...
    (comp.databases.ms-access)
  • Re: [Info-Ingres] Invitation to a quarrel
    ... I can see a case for a unique key with null, but not a primary key based ... I claim that the design of the database tells us things about ... The ANSI/ISO standard requires that all the components of a primary key ...
    (comp.databases.ingres)
  • Re: junction tables for 3 many to many relationships
    ... aspects of design that I think are relevant. ... because the 4 fields could serve as a composite primary key. ... >> absolutely identifies a unique record. ... the ID's are aluminum bands placed on the legs of birds. ...
    (microsoft.public.access.tablesdbdesign)