> On Mar 8, 2017, at 6:26 AM, Two Way Communications via 4D_Tech > <[email protected]> wrote: > > 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.
After doing this import (or any other import where you assign an ID that did not come directly from Sequence number), have you verified that the Sequence number is greater than the largest imported number? If not, you might be just seeing the same problem over and over. You can use something like this for each ID field: SCAN INDEX($id->;1;<) //largest value $last:=$id-> If (Sequence number($table->)<$last) SET DATABASE PARAMETER($table->;Table sequence number;$last) End If John DeSoi, Ph.D. ********************************************************************** 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] **********************************************************************
