will do. -----Original Message----- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 11:43 AM To: [email protected] Subject: Re: [plum] Database Relationship Question
John, Why don't you call me at 770-446-8866 between 1:00 PM and 3:00 PM today? Be next to an Internet-connected Windows computer when you call. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ----- Original Message ----- From: "John Stanley" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, June 08, 2005 11:38 AM Subject: RE: [plum] Database Relationship Question > that's fine with me. at least everyone by default wont be viewing an edit > screen! ;-) so that is a HUGE improvement. > > anytime before 3:45 eastern m-f is fine with me. > > -----Original Message----- > From: Adam Churvis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 08, 2005 11:29 AM > To: [email protected] > Subject: Re: [plum] Database Relationship Question > > > Yeah, I remember us talking about your requirement for this at our office. > It still makes my skin crawl because of all the problems this is probably > going to call you, but if you insist... > > John, why don't we schedule a time for you to call me so that we can share > my desktop while I model this up for you live using ER/Studio based on our > discussion? > > Respectfully, > > Adam Phillip Churvis > Member of Team Macromedia > http://www.ProductivityEnhancement.com > > Download Plum and other cool development tools, > and get advanced intensive Master-level training: > > * C# & ASP.NET for ColdFusion Developers > * ColdFusion MX Master Class > * Advanced Development with CFMX and SQL Server 2000 > > ----- Original Message ----- > From: "John Stanley" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, June 08, 2005 8:23 AM > Subject: [plum] Database Relationship Question > > > > Hiya all, > > > > Just a general question. Trying to tap into the db expertise a bit, I > guess. > > > > say I have a db with this table: > > > > shipment > > > > and these tables are dependent on the shipment table: > > > > quotes > > cargo > > notes > > et al > > > > > > then I have this table: > > > > lock > > > > and this table: > > > > description > > > > and in the lock table there is a column called lockType (int) which > > corresponds to the description table PK. this will give the code an idea > > which TABLE is being edited by the user. then the lockTypeID will tell the > > code which of the ROWS in that table are currently locked for editing by > the > > user. > > > > basically this functionality is so that if a user attempts to EDIT some > data > > part on a shipment, the system will first check to see if it is locked by > > another user, and if so, just direct them to the VIEW screen with an > > appropriate message. > > > > with this schema I cannot make a fk relationship between the children > tables > > of the shipment table and the lock tables lockTypeID column. > > > > What kind of relationship is this called? > > > > Is it a bad thing to do it this way? If so, why? > > > > The only other solution I can see is to have one or more columns in each > of > > the editable tables I wish to control to store the locking information. > > > > Can you see any problems with either methods. > > > > Thanks to anyone who has some input. > > > > John Stanley > > Web Application Developer > > Active Aero Group > > http://www.activeaero.com > > 734-547-7200 office > > > > > > > > > > > > > > > > > > ********************************************************************** > > You can subscribe to and unsubscribe from lists, and you can change > > your subscriptions between normal and digest modes here: > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > ********************************************************************** > > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
