When you test it may work, but when it is used by multiple users it will result in duplicate ids. There are various ways to do this. PatternNumber If Not IsNull varCode Then ' has a number been added to the letters? The best you can come is to store your last value in a database or a file, then load that up on each script execution. Please mark those posts as answer which answers your question. Create a unique index on these two columns. The method you have used is error prone.
Serial numbers imply being serial after all. The complexity of implementing such an alternative is sufficient, that if you did not already know what I just explained, you should stick with autoincrement fields, they are very easy to use and fairly bullet proof. You can problably use any one of the two approaches. One such source of an atomic counter is memcache. I need some advice and if a scipt will have to be written can you advice me to some topic where I can learn more about scripting and retrieving data from sharepoint.
That said I will propose two of the many alternatives. I think you may need to give more information about what you are doing and what the goal is. The value should be a Unique One. Web services can be written in any number of languages. The first user to save the record would succeed, but the others would get an error. Provide an answer or move on to the next question. I am not sure how you are making textbox and list dataconnected? One request that shows up again and again on the Adobe Forums or in the past on AcrobatUsers.
I am publishing the form on Sharepoint. The last thing we do is to hide the button that was used to generate the serial number. I need this one to help keep the serial number in order as the rows on the table will be deleted any time and when that happens, the figures will beginto skip. Don't enter anything in the Index name column for this row. Using an autoincrement field avoids this issue.
. Explain more and I'm sure you'll get lots of help. I solved this problem simply using SharePoint. There is of course otherways to do this, this however is the correct one in nearly all cases. If you are just saving to a filesystem, you'll unfortunately need to generate your own unique identifier. Have two columns PatternNumber and PatternCode, the latter being for the alphabetic element. The crux of the problem is the need for an atomic counter, that is a counter that does not suffer from the race condition described above, and will always return the next unique id.
Oftentimes web services are written in Java and are then executed in an application server like Apache Tomcat. Let's work to help developers, not make them feel stupid. You can install for example the free software on a Windows 10 computer and still get the same behavior as you would with a real server system. You can create an other column Auto Numbered in your data base which could be used as a serial number because they all will be unique. There are other potential pitfalls. Depending on where your function is, it might not have access to the variable.
There could be more error checking and exception handling in this code, but I did not want to clutter up the actual functionality with that. This can either be a table lock where in you lock the table, select the max id increment, insert and unlock the table, this requires the use of transactions as well and so will further complicate what could be very simple code. Thanks Kromey for ur suggestion. We also need a mechanism to request a new serial number — in the sample below, that will be done using a button. How can the same functionality be implemented if the requirement is to use this on multiple computers, or by multiple users? Like all solutions this has it's downfalls, if your memcache goes down you will loose your state, and the counter will start over, thus not being so unique.
View one of the pages that need this feature by clicking this link. That should get you stated, though I don't like having the two tables storing what are in essence are duplicates of the same data. But the thing for which i am searching is like a receipt No: it is to issue a customer a receipt with curdate and his rtno like 001,002. In pre 2007 versions this is done in table design view by selecting Indexes from the View menu; in 2007 Indexes on the Design ribbon. If you're doing this across multiple executions which I find to be the most likely scenario , then there really isn't an easy way to do this.