Hi Pat, Set the method property to "Execute on Server".
This shared object/collection could also have a collection of numbers that need to be reused if you require that there are no missing numbers in your sequence. Of course, you'll have to get the database involved at some level to handle startup and shutdown and the case where the server crashed without writing the last sequence number used. John DeSoi, Ph.D. > On Aug 25, 2018, at 10:21 AM, Pat Bensky via 4D_Tech <[email protected]> > wrote: > > Thanks John. > But how would that work in a multi-user setting? Whatever method is used > for assigning the new numbers, it must run on the server, otherwise we're > back to the problem of using semaphores, checking record locking, etc. > Also I should point out that there could be a large number of tables for > which the record numbering system needs to be used. We have a RecordNumbers > table which has one record for each table that requires this function. so > we must have ONE process that accesses and updates that table. > PB ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
