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:

Re[2]: 2nd WebCatalog2 Feature Request (1996) ASP and WebCatalog ?? (2000) [OT] Domain Name Scam (2000) [WebDNA] BUG REPORT [MATH show=t] WebDNA 8.6.1 & 8.6.3 server (2019) RE: includes and cart numbers (1997) Displaying photo attached to first record (1997) blank page from template (1997) OK, here goes... (1997) Secure server question (1997) Multiple Pulldowns (1997) Emailer errors (1997) db=xxx.db param have to be first? (2000) [searchString] (1997) How do I get Google to crawl a WebCat site? (2003) Problems passing [SKU] with $Replace in 2.0 (1997) [SHOWIF AND/OR] (1997) Summing fields (1997) Banners (1997) WC1.6 to WC2 date formatting (1997) WebCat2 several catalogs? (1997)