I'll add my vote to Jody's approach. I prefer UUIDs for primary keys for all the reasons mentioned. Having a longint index field is useful as well but for different reasons as Jody explains. My most common use is to be able to quickly sort a table in the order records were created. And it is superior for referencing records - attempting to type a UUID is not something one wants to do.
On Fri, Aug 4, 2017 at 6:51 AM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com > wrote: > On another note, we assign a counter ourselves (not auto generated). There > are times where we reset counters and being able to do that is great. > Resetting the counter can be done with ​SET DATABASE PARAMETER ( [Table] ; Table sequence number ; value ). I haven't had any issues with bad sequence numbers since about vers 6. -- Kirk Brooks San Francisco, CA ======================= *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************