Re: Stupid Database Tricks

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 24 May 2007 19:10:23 -0700
Message-ID: <1180059023.901581.101860@k79g2000hse.googlegroups.com>

>> Drives me crazy, too. I'm not sure why. Maybe it's because it's such persistent mythology. <<

Hey, I have looong rants on this topic. I like to pull out the Dr., Codd quotes about what a surrogate key really is and then mention that the Kabbalah also thinks that everything is keyed by God with a 17- digit Hebrew number as its true name.

>> I may have discovered at least one origin of this bad design habit .. Access 97. It turns out that, if you build a database with one of the database wizards, this is usually what you get. <<

I like to to think that it is an attempt to mimic a pointer chain file system in SQL, but without the double linkage, utility programs, etc. that made them actually work.

But you are probalby right given the level of Newbie coders today who learns on ACCESS .. Received on Thu May 24 2007 - 21:10:23 CDT