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

Reply via email to