dbdebunk 'Quote of Week' comment



Hi all,
I'm enjoying reading C. J. Date's new book "Database in Depth", in
which I know the www.dbdebunk.com website. I visited the site just now,
and find the following statement in its "QUOTE OF THE WEEK" section:

** QUOTE **
Don't use primary keys that have meaning for the end user, such as
invoice number or the ISBN value.

--Giuseppe DiMauro & Francesco Balena, PRACTICAL GUIDELINES AND BEST
PRACTICES FOR MICROSOFT VISUAL BASIC AND VISUAL C# DEVELOPERS
** QUOTE **

It seems that they quote this idea to point out how wrong it is. But
I myself always regard this idea as a good practice in database design!
Am I right? If not, what's wrong with it? Please comment.

.



Relevant Pages

  • RE: Crystal Report or MS Word?
    ... Access databases and uses Crystal Reports 5.0 to generate a quote. ... modified the old VB4.0 code to allow users to save the Crystal Report ... saved in the database and the modifications made in Word are not so you ... As I upgrade this program to VB.net, I am trying to clean up this whole ...
    (microsoft.public.dotnet.languages.vb)
  • Crystal Report or MS Word?
    ... Access databases and uses Crystal Reports 5.0 to generate a quote. ... modified the old VB4.0 code to allow users to save the Crystal Report ... saved in the database and the modifications made in Word are not so you ... my application fill in a Word Template with the quote data. ...
    (microsoft.public.dotnet.languages.vb)
  • Query between databases
    ... I built a seperate database which will be ... in the Price Book database as it is owned by my wifes company and I ... I built the database called Quote Builder and was able to create a set ... of queries to pull information from the Price Book DB into the Quote ...
    (microsoft.public.access.queries)
  • Re: Crystal Report or MS Word?
    ... Unfortunately, I don't know enough of the details of your app, to help ... records into the database whenever a change is made - therefore keeping ... Access databases and uses Crystal Reports 5.0 to generate a quote. ... modified the old VB4.0 code to allow users to save the Crystal Report ...
    (microsoft.public.dotnet.languages.vb)
  • Word Document or Report...which to use?
    ... program takes user inputs, performs calculations, saves the data to ... Access databases and uses Crystal Reports 5.0 to generate a quote. ... modified the old VB4.0 code to allow users to save the Crystal Report ... saved in the database and the modifications made in Word are not so you ...
    (microsoft.public.dotnet.languages.vb)