Sequence number does not increment unless you create or duplicate a record.
John DeSoi, Ph.D.
> On Nov 16, 2016, at 3:21 AM, Sujit Shah <sujit...@gmail.com> wrote:
>
> READ WRITE([Contact_Listing])
> For ($i;1;Size of array($alDuplicateIDs))
> QUERY([Contact_Listing];[Contact_Listing]ID=$alDuplicateIDs{$i})
> While (Not(End selection([Contact_Listing])))
> [Contact_Listing]ID:=Sequence number([Contact_Listing])`HERE IT IS GIVING
> THE SAME SEQUENCE NUMBER TWICE
> SAVE RECORD([Contact_Listing])
> NEXT RECORD([Contact_Listing])
> End while
> End for
> READ ONLY([Contact_Listing])
**********************************************************************
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
**********************************************************************
