> Le 8 mars 2017 à 13:26, Two Way Communications via 4D_Tech > <[email protected]> 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:[email protected] **********************************************************************
