I am trying to duplicate a number of records using ORDA. I have an ID field that uses sequence numbers but is not the primary key of the table. The Primary Key is a UUID field. When i attempt to duplicate a record like this in a loop the sequence number does not increment but returns the save value over and over. Is there a way to make this work?
$esRecs:=ds.Complex.query(“Domain_ID = :1”;$vnFromDomainID)
For each ($eRec;$esRecs)
$eNewComplex.ID:=Sequence number([Complex]) //Does not increment with each orda record created
End for each
Product :4D - 4D Server
OS : Windows