Search DaniWeb - simultaneous

Simultaneous order placement 13 Years Ago by stevija Hello, I've got a problem with simultaneous placement of an order in a webshop. I will start … obtained, the order is written away. However it looks like simultaneous calls of the billnumber routine sometimes give the same billnumber… Re: Simultaneous order placement 13 Years Ago by stevija …'t that have the same problem? For example when 2 simultaneous calls are made to aquire the max number, and the… max can be the same in this way with 2 simultaneous calls if the insert statement is not executed yet, but… Re: Simultaneous order placement 13 Years Ago by stevija I agree making it unique ensures no duplicates in the table, but it still does not exclude the billnumber-routine potentially providing the same billnumber at simultaneous requests. When making billnumber unique, the second order would simply not be inserted and be lost. Simultaneous Operation of Several Networked Computers 17 Years Ago by FireSBurnsmuP … if anyone knows how to accomplish this, that is the simultaneous operation of several computers on a single task. I'm… simultaneous updates on a database 13 Years Ago by Ziyanda hi guyz! I've recently finished a database project in Access 2003 and have been asked to deploy it to network machines with Access 2007. the prblm i have is that the users r unable to add and update the records at the same time. how can i ensure that simultaneous updates on the database are possible. thanx in advance!!! Re: simultaneous MS Access Database access problem using VB6 program. 16 Years Ago by dilip_singh3 … the bold lines below in the code we can handle simultaneous access Private Sub Command1_Click() [B]CNN.BeginTrans[/B] If Not… Re: simultaneous use of a form 14 Years Ago by niche1 …] Thanks. Except, my question has more to do with the simultaneous use of variables. How can a scripter avoid a situation… Re: simultaneous use of a form 14 Years Ago by ShawnCplus …]Thanks. Except, my question has more to do with the simultaneous use of variables. How can a scripter avoid a situation… Operating Systems - choice - simultaneous or alternative 18 Years Ago by sunandoghosh Operating Systems - choice - simultaneous or alternative exploring different possibilities...!!!!!!!! Respected Gurus and dear friends, … How to Find the no of simultaneous users logged in? 15 Years Ago by Robins Antony Hi friends, How to Find the no of simultaneous users logged in to a web site at a time?. Any help with the C# code will b greatly appreciated. Regards Robins Re: How to Find the no of simultaneous users logged in? 15 Years Ago by skatamatic … Antony;828710]Hi friends, How to Find the no of simultaneous users logged in to a web site at a time… Puzzling result w/ simultaneous double loops (Very simple program) 13 Years Ago by sgw …], it's fine. Also, if, instead of the short cut simultaneous loop [CODE]for (int i=0,j=0; i<… Re: Puzzling result w/ simultaneous double loops (Very simple program) 13 Years Ago by sgw … is excellent and really makes sense. A question about the simultaneous loops: is the above (after your correction) equivalent to [CODE… how Simultaneous enable gzip and $STR_REPLACE=(in cgi) in apache 8 Years Ago by body212 Hi, i have a code in my cgi script for replace text(for example replace red ro blue) $STR_SEARCH='red' $STR_REPLACE='blue' this work fine.but when i want use gzip for compression,gzip will not work but when i disable the replace,gzip will be work fine. please help me ,that how i can enable the replace and gzip Simultaneous . thx solving a linear simultaneous equation of 10 variable 6 Years Ago by Godwin_3 urgent need: write a computer program in c++ that solves a linear simultaneous equation of 10 variable Re: Simultaneous order placement 13 Years Ago by urtrivedi I faced same problem, I guess your billnumber column may remain blank for sometime. So I created on more table say billmaster (billnumber pk). If you want to generate bill number every year then (billnumber pk, year pk). Now in your billnumber generation. you fetch max number from billmaster table then insert it in billmaster table, return that … Re: Simultaneous order placement 13 Years Ago by debasisdas why not simply try BillNumber = max(BillNumber) +1 Re: Simultaneous order placement 13 Years Ago by urtrivedi if you are not keeping billnumber blank and if you can insert billnumber with orderid, then simply define billnumber as unique key. Then it will not allow duplicate billnumbers. Re: Simultaneous order placement 13 Years Ago by tomato.pgn or u can also do one thing just make the field in db autoincrement if it is only numeric...otherwise just add a query to find max billid and increment it by 1..... Re: Simultaneous order placement 13 Years Ago by urtrivedi simple solution is make billnumber uniquekey Re: Simultaneous order placement 13 Years Ago by debasisdas Why not check for existence of the value generated (using +1 technique) once before inserting. If it exists increment the same further (+1) and insert. Re: Simultaneous order placement 13 Years Ago by debasisdas [QUOTE=stevija;1540248] the second order would simply not be inserted and be lost.[/QUOTE] that is when my previous solution will come handy Re: Simultaneous order placement 13 Years Ago by smantscheff Bracket the whole order process with START TRANSACTION and COMMIT respectively ROLLBACK in case of any errors. Re: Simultaneous order placement 13 Years Ago by stevija [QUOTE=debasisdas;1540242]Why not check for existence of the value generated (using +1 technique) once before inserting. If it exists increment the same further (+1) and insert.[/QUOTE] With your suggestion every order would go through the following three steps. A. Get the billnumber + 1 B. Check before insert if the billnumber exists C. … Re: Simultaneous order placement 13 Years Ago by debasisdas yes, now use suggestion by [B]smantscheff[/B] i.e.---commit after every transaction. as per your situations User 1 executes Step C (the order with billnumber 51 is inserted) [B]commit[/B] User 2 executes Step C (the order with billnumber 51 [B]will not be insert as it is duplicate and 52 will be inserted.[/B] Re: Simultaneous order placement 13 Years Ago by stevija Hmm, transactions seem to be just what I need :) Steps I'll make for the solution: - Making the billnumber field unique - Make a transaction of the order process, that loops until succesful Thanks for the help guys! It's appreciated Best regards, Chris Re: Simultaneous Operation of Several Networked Computers 17 Years Ago by John A Something like this? [url]http://www.linux.com/article.pl?sid=06/03/29/1857227[/url] Re: Simultaneous Operation of Several Networked Computers 17 Years Ago by FireSBurnsmuP As usual, JP, you have insane amounts of varying random knowledge. So this PVM separates out a process to be done simultaneously in several computers? This is sweet, but how hard is it to program something to work simultaneously on several computers with PVM? Re: Simultaneous Operation of Several Networked Computers 17 Years Ago by John A >As usual, JP, you have insane amounts of varying random knowledge. If you're referring to Google, then yes, you are correct. ;-) >So this PVM separates out a process to be done simultaneously in several computers? The way I understand, you would probably split up your program into threads, which you would send to individual computers for … simultaneous MS Access Database access problem using VB6 program. 16 Years Ago by dilip_singh3 I am using MS Access database by a vb6 program for multiuser environment. In the program I have written code for autogenerating employee_id which is primary key in the table. When entering records simultaneously from two or more workstation, It gives a problem Run time error The changes you requested to the table were not successful because…