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 On 7/27/05, Kevin Graeme <[EMAIL PROTECTED]> wrote: > What about multiple application interfaces? Sure right now it's all > going through a VB app, but what happens when you want to use the VB > app for the internal business side but have parts of the data tied in > to a CF web app for extranet customers or something? > > -Kevin > > On 7/27/05, Marlon Moyer <[EMAIL PROTECTED]> wrote: > > I've just recently noticed that one of our databases in sqlserver has > > no relationships defined. I talked with the 'dba' about this and he > > told me that all of that logic is contained in the VB app that updates > > the data. I'm not saying that there aren't any foreign keys defined, > > just that he's not specified that relationship inside of the db. So I > > talked with my supervisor and he wanted some examples of why we should > > move the logic out of VB and into the database. > > > > Aside from the obvious reason of keeping the db logic inside of the db > > and built in referential integrity, I was stumped. I thought given > > the relationships, sqlserver gets hints as to how to speed up joins > > and such. I've already suggested that different programs that use the > > data wouldn't have to recreate the integrity logic, but I need > > more.........or maybe I don't. Maybe it's fine to keep this in VB? > > > > > > -- > > Marlon > > > > "I don't believe in heaven or hell, no saints, no sinners, no devil as > > well, no pearly gates, no thorny crown, you're always looking us > > humans down" > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Now thereâs a better way to fax. eFax makes it possible to use your existing email account to send and receive faxes. Try eFax free. http://www.houseoffusion.com/banners/view.cfm?bannerid=63 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:166824 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
