I think you are fighting a noble but losing battle. Many people prefer to do what you are suggesting they don't.
They have their reasons, and don't care about yours. RDBMS are designed with relationships in mind, that is the purpose of the system to relate groups of data with other groups of data, and keep the integrity. It is the sign of developers that are more worried about getting it done fast than getting it done right. > -----Original Message----- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 27, 2005 4:02 PM > To: CF-Community > Subject: Re: Relations in the db > > That's the angle I'm trying to use, but as it stands now, there's no > other app creating the data aside from the VB app. I've found out > that the reason it was left out originally was that the designer > thought it would be faster and having a defined relationship precludes > the use truncating a table. > > Marlon > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:166842 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
