Kirk Brooks: > If a subsequent call to sequence number is made it causes the sequence to > increment. So the final call my test method makes causes the sequence to > increment by 3 even through at the time that call is made the other > processes have quit and 'released' their numbers.
Yes, if you try to follow the logic it might be a bit strange but what counts for me is: It just works. I use Sequence Number to fill my primary key fields for ages. In the last milennium there was a bug with Sequence numbers but that has long been fixed. You don´t have to think about multiple processes, transactions, etc. if you use the Sequence Number command. Of course you could run your own, but why would I do that? Never change a running system. (Just my 2 Eurocent) Greetings from Germany, Bernd Fröhlich ********************************************************************** 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:[email protected] **********************************************************************
