I have been using autonumber for almost 10 year to generate sequential work orders (10,000-15,000 work orders per year) and I have not had any problems. The work order number is formatted (02-XXXXX) and I have a utility that at the end of the year resets it to the next years (03-XXXXX) or it can reset it to the next number for the previous year.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Vellella Sent: Monday, December 16, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: Re: RTime, Table Locks, and Multiple Users Damian, I would look into using autonumber on your PO number field. On my multi-user runtime application I use it and it never fails to give the most current accurate number assignment. Steve Vellella Damian wrote: > We have 8 users that access a purchase order system over a network. The > users are running RTime for Windows 1.851 installed on each of their > workstations running windows 98 or windows 2000. The database and > programs are located on a separate computer running windows 2000. When > a new purchase is added to the system a number is automatically > generated for it. This is where the problem occurs. We have a table > that stores the current number and is accessed and incremented each time > a new order is entered. In the code, we set a lock on the table, fetch > the current number, increment it by one, update the table, set the lock > off and proceed to the po entry screen. > > For some reason, every odd couple of days and entries the number is not > calculated properly. I have made a log file to monitor the > assignments. What I see in the log file is that everything is working > fine for all of the users and then suddenly one of the users tries to > enter a new po. The number that is fetched from the table is > incorrect. I have seen it fetch a number that was used 10 POs ago or > maybe a number that was used 3 POs ago. I don't understand how. > > I know that when RTime exits normally it erases the $$$ files and if not > then they are left alone. Is it possible that one of these is getting > re-used and supplying incorrect information. > > Any thoughts, suggestions, ideas are greatly appreciated. > > Damian > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
