topic Re: Unique value in short integer field in Developers Questions https://community.esri.com/t5/developers-questions/unique-value-in-short-integer-field/m-p/21455#M134 <HTML><HEAD></HEAD><BODY><P>First of all are you aware that the range for a signed short integer is between -32767 and 32767.&nbsp; If this is adequate for job then the next series of question would be is how is this being used/inputed/stored.</P><P></P><P>Not knowing specifics Two ways come to mind:</P><P></P><P>1. Using the database/triggers/procedures create your own auto increment.</P><P>or</P><P>2. Programmatic means issue a query to yous data source max(yourfield) + 1</P><P></P><P>If you are mobile and disconnected from your data store that create other additional difficulties.&nbsp; As an example I have Bridge Inspectors that go out and Identify Bridge Maintenance needs.&nbsp; Each "Need" must be a unique number but I cannot tell or give the number out in the field.&nbsp; So to get around this -- each mobile app (my case an excel spreadsheet) generates a "local" unique Identifier.&nbsp; When the local data is submitted to me and after Q/A&nbsp; I upload this data to the central repository - Part of my upload process generates the "Next" available unique number to the Need by programmatic means.&nbsp; The Q/A'd application then assigns the local data the "official" Unique Value.</P><P></P><P>Hopefully this will trigger some ideas to get you unstuck.....</P></BODY></HTML> Fri, 18 Mar 2016 16:53:20 GMT TedKowal 2016-03-18T16:53:20Z Unique value in short integer field https://community.esri.com/t5/developers-questions/unique-value-in-short-integer-field/m-p/21454#M133 <HTML><HEAD></HEAD><BODY><P>Anyone know how to set up a short integer field so it will only accept a unique value?&nbsp; I'm doing a tree inventory using Collector and need a unique number to identify each tree.&nbsp; Maybe a "next available" number setup would work.&nbsp; Any thoughts?</P></BODY></HTML> Fri, 18 Mar 2016 02:37:58 GMT https://community.esri.com/t5/developers-questions/unique-value-in-short-integer-field/m-p/21454#M133 JeffBaker2 2016-03-18T02:37:58Z Re: Unique value in short integer field https://community.esri.com/t5/developers-questions/unique-value-in-short-integer-field/m-p/21455#M134 <HTML><HEAD></HEAD><BODY><P>First of all are you aware that the range for a signed short integer is between -32767 and 32767.&nbsp; If this is adequate for job then the next series of question would be is how is this being used/inputed/stored.</P><P></P><P>Not knowing specifics Two ways come to mind:</P><P></P><P>1. Using the database/triggers/procedures create your own auto increment.</P><P>or</P><P>2. Programmatic means issue a query to yous data source max(yourfield) + 1</P><P></P><P>If you are mobile and disconnected from your data store that create other additional difficulties.&nbsp; As an example I have Bridge Inspectors that go out and Identify Bridge Maintenance needs.&nbsp; Each "Need" must be a unique number but I cannot tell or give the number out in the field.&nbsp; So to get around this -- each mobile app (my case an excel spreadsheet) generates a "local" unique Identifier.&nbsp; When the local data is submitted to me and after Q/A&nbsp; I upload this data to the central repository - Part of my upload process generates the "Next" available unique number to the Need by programmatic means.&nbsp; The Q/A'd application then assigns the local data the "official" Unique Value.</P><P></P><P>Hopefully this will trigger some ideas to get you unstuck.....</P></BODY></HTML> Fri, 18 Mar 2016 16:53:20 GMT https://community.esri.com/t5/developers-questions/unique-value-in-short-integer-field/m-p/21455#M134 TedKowal 2016-03-18T16:53:20Z