Re: several people editing a database.

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38915
interpreted = N
texte = Whoever saves last wins. You would need to implement some sort of record locking, e.g. When someone is in edit mode, update a flag field in the database that does not let anyone else edit it. Kind of like a pre-edit. Then on saving of the field, clear the flag.The only problem is that if someone just views the details without editing it you could leave that flag set. Maybe add a second field with a time/date stamp and have a trigger run say each hour and clear the flag on any field more than xx minutes old.Daleon 9/26/01 4:27 PM, Donovan Brooke at dbrooke@ehg.net wrote:> quick quesiton: > any input as to whether or not letting mutiple people administer some of the > databases is O.K.? > if two people are editing the same record what happens? thx. > > > -- Donovan D. Brooke > Systems Administrator/ > Assc. Art Director > Epsen Hillmer Graphics > > > I know I'm making progress when I look at the questions I have > asked in the past and think to myself... how stupid was that ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: several people editing a database. (Terry Nair 2001)
  2. Re: several people editing a database. (dale 2001)
  3. several people editing a database. (Donovan Brooke 2001)
Whoever saves last wins. You would need to implement some sort of record locking, e.g. When someone is in edit mode, update a flag field in the database that does not let anyone else edit it. Kind of like a pre-edit. Then on saving of the field, clear the flag.The only problem is that if someone just views the details without editing it you could leave that flag set. Maybe add a second field with a time/date stamp and have a trigger run say each hour and clear the flag on any field more than xx minutes old.Daleon 9/26/01 4:27 PM, Donovan Brooke at dbrooke@ehg.net wrote:> quick quesiton: > any input as to whether or not letting mutiple people administer some of the > databases is O.K.? > if two people are editing the same record what happens? thx. > > > -- Donovan D. Brooke > Systems Administrator/ > Assc. Art Director > Epsen Hillmer Graphics > > > I know I'm making progress when I look at the questions I have > asked in the past and think to myself... how stupid was that ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ dale

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Privacy Issue (LEGIT QUESTION) (2003) Using tags to create a file name (2000) show all problem (1997) Pass Thru Page? (1998) Error Messages Returned to User (1997) Multi-processor Mac info ... (1997) all records returned. (1997) no template caching (1997) Superfilous Characters (1998) 'does not contain' operator needed ... (1997) pc (1997) Hard Questions ? (1997) using showpage and showcart commands (1996) search form problem.. (1997) Request for page test (2003) Draft Manual, Tutorial, and more (1997) restarting webcatalog (2002) Cool XML/XSLT tool .. (2002) WC Database Format (1997) upgrading (1997)