Hi Arnaud, Yes, it is only 4D v15.4 (haven’t tried yet with v15R4)
Index kind: I tried all, no difference It is a small table (20.000 records) Rebuilding the index fixes the problem for a short while, but it returns. Database has been compacted twice, no errors. I wonder … has anybody else had issues with Primary keys in combination with sequence number? Regards, Rudy Mortier Two Way Communications bvba ----------------- > On 08 Mar 2017, at 14:43, Arnaud de Montard via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > >> Le 8 mars 2017 à 13:26, Two Way Communications via 4D_Tech >> <4d_tech@lists.4d.com> a écrit : >> >> Hi all, >> >> I ran into an issue while using SEQUENCE NUMBER in 4D v15.4, in a >> client-server setup. >> >> I put the result in a field called ‘ID’, which is the primary key for that >> table, and by default is unique. Auto increment is off. >> The code is running in a transaction. > > I do the reverse: > - auto increment on > - no sequence number call > Let's say I'm lazy enough to consider primary key delivery is the DB job, not > mine… > > But it seems your problem is the index, as you mention rebuilding fixes the > issue. > What is the index kind? > Big table? > Is it only since v15.4? (I should have started by this…) > > -- > Arnaud de Montard > > > > ********************************************************************** > 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 **********************************************************************