You're right, not defining the relationships won't cause anything to crash, but can compromise the integrity of your database
----- Original Message ----- From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 10:52 AM Subject: Re: Defining internal DB relationships necessary? > > Are you sure that the "relationships" are only used in the Access GUI? My > > understanding is that they were true constraints. > > You're right, I believe - only I've never had a single problem > so far with not defining them inside the DB (apart from PK's, > which Access forces, and I've got into the habit of defining > by default). > > "So far" is probably the operative part of this, though! I'm > incredibly thorough with my code that inserts data, but > I appreciate that I should get into the habit of defining > relationships explicitly. > > I was asking really to make sure I didn't get any replies going, > "Ohmigod!! You haven't defined the relationships!! All your > sites are about to crash!" Well, as I said, nothing bad so > far, but will bear this advice in mind... > > cheers, > > - Gyrus > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > - [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://www.norlonto.net > - PGP key available > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists