I was trying to do a quick fix. Does not matter in this case if it skips one.
Thanks all for pointing out why the sequence numbers were not incrementing. Brain warp working overtime :-( On Thu., 17 Nov. 2016 at 5:32 am, Alan Chan <a...@belhk.com> wrote: > Why do you want to do [contact_Listing]ID+1? > > I believe the command will add one to the number you entered next time > sequence number is called. In your case, the system will skip one number. > > Alan Chan > > 4D iNug Technical <4d_tech@lists.4d.com> writes: > >ALL RECORDS([Contact_Listing]) > >ORDER BY([Contact_Listing];[Contact_Listing]ID;>) > >LAST RECORD([Contact_Listing]) > >SET DATABASE PARAMETER([Contact_Listing];Table sequence > >number;[Contact_Listing]ID+1) > > ********************************************************************** > 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 > ********************************************************************** ********************************************************************** 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 **********************************************************************