Can a database get stomped by simultaneous access?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13033
interpreted = N
texte = We use a database to maintain an incremental counter we use as an invoice order number with our webcat online orders, but we have had problems in which every so often (we suspect it could be when we need to restart) we get duplicate numbers for the counter in that database. The ourDBs/Invoice_Counter_No.db contains just two fields [CART] and [InvoiceNo] it started with a 0 value for a cart (which gets replaced by the cart generated by webcat) and the desired invoice number we wish to start from when we brought our online system up. Below is a sample code snippet of what we do:[CLOSEDATABASE ourDBs/Invoice_Counter_No.db] [HideIf [lookup db=OurDBs/Invoice_Counter_No.db&Value=[CART]&lookInField=CART&returnField=C ART¬Found=0]=[CART]] [Replace db=OurDBs/Inv_Receipt_No.db&eqCARTdata=0]CART=[CART][/Replace] [Append db=OurDBs/Invoice_Counter_No.db]CART=0&InvoiceNo=[math][lookup db=OurDBs/Invoice_Counter_No.db&Value=[CART]&lookInField=CART&returnFiel d=InvoiceNo]+1[/math][/append][/Hideif] The question is if we add a [closedatabase ourDBs/Invoice_Counter_No.db] form after this operation could two customers simultaneously trying to place an order stomp this database? Is webcat smart enough to keep a database open if an operation is occurring on it even though another customer may have hit the closedatabase form from another order?Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ---------------------------------------------------------------------- Associated Messages, from the most recent to the oldest:

    
  1. RE: Can a database get stomped by simultaneous access? (w curt eggemeyer 1997)
  2. RE: Can a database get stomped by simultaneous access? (w curt eggemeyer 1997)
  3. RE: Can a database get stomped by simultaneous access? (Sven U. Grenander 1997)
  4. RE: Can a database get stomped by simultaneous access? (Marc Eagle 1997)
  5. Can a database get stomped by simultaneous access? (w curt eggemeyer 1997)
We use a database to maintain an incremental counter we use as an invoice order number with our webcat online orders, but we have had problems in which every so often (we suspect it could be when we need to restart) we get duplicate numbers for the counter in that database. The ourDBs/Invoice_Counter_No.db contains just two fields [cart] and [InvoiceNo] it started with a 0 value for a cart (which gets replaced by the cart generated by webcat) and the desired invoice number we wish to start from when we brought our online system up. Below is a sample code snippet of what we do:[CLOSEDATABASE ourDBs/Invoice_Counter_No.db] [HideIf [lookup db=OurDBs/Invoice_Counter_No.db&Value=[cart]&lookInField=CART&returnField=C ART¬Found=0]=[cart]] [Replace db=OurDBs/Inv_Receipt_No.db&eqCARTdata=0]CART=[cart][/Replace] [Append db=OurDBs/Invoice_Counter_No.db]CART=0&InvoiceNo=[math][lookup db=OurDBs/Invoice_Counter_No.db&Value=[cart]&lookInField=CART&returnFiel d=InvoiceNo]+1[/math][/append][/Hideif] The question is if we add a [closedatabase ourDBs/Invoice_Counter_No.db] form after this operation could two customers simultaneously trying to place an order stomp this database? Is webcat smart enough to keep a database open if an operation is occurring on it even though another customer may have hit the closedatabase form from another order?Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ---------------------------------------------------------------------- w curt eggemeyer

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:

Invisible file issue now a real 'bug' (1999) Can you do this??? and other stuff (1997) WriteFile is there a max size? (1998) page redirect in webDNA (1997) Languages (1997) Aaron kant add (or whatever it was) (2000) Writefile problem (1999) HELP WITH DATES (1997) problem: mail changed (1997) New Line In grep (2003) Re:Help name our technology! (1997) tcp connect includes (1999) Locking up with WebCatalog... (1997) details (2003) New public beta available (1997) Signal Raised (1997) shared_POP and archiving your own mailing list (2003) Help name our technology! (1997) Encrypting the seed (2001) [URL] and [showif] or [hideif] comparisons (2003)