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. Frequently, users get the error ‘Cannot save the record, DUPLICATE KEY’. Then, I go to the structure and rebuild the index on that field (ID). They try again, and the record is saved without a problem. After a while, though, and after other users have added records to this table, the problem re-occurs. Rebuilding the index again fixes the problem. I have exported the data to a tab delimited file, truncated the table, and imported the data. Problem is still there. I have compacted the data file. Same problem. Any ideas what can be the cause? Kind regards, Rudy Mortier Two Way Communications bvba ----------------- ********************************************************************** 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] **********************************************************************
