If you are not too far along I would consider not using 4Ds built in method to create these keys. I and others have posted code to do this. Second you can check tables to ignore primary keys but that means data will not be backed up for those tables
Regards Chuck Sent from my iPhone > On Oct 24, 2017, at 6:15 AM, Kirk Brooks via 4D_Tech <[email protected]> > wrote: > > Ronnie, > > You can use the Generate UUID command to fill or regenerate a the key > fields. > > On Tue, Oct 24, 2017 at 2:49 AM, Ronnie Teo via 4D_Tech < > [email protected]> wrote: > >> Hi All, >> >> Need to seek some advice in converting a client’s database from v11 to v15. >> >> For one of the tables, 4D reported that the primary key contains NULL >> values upon conversion or that the primary key contains duplicate values. >> >> The primary key was defined to be a UUID-type value. >> >> So if some of the records are blank for the primary key, how do we proceed >> from there? >> Also, if 4Dv15 is assigning the primary key when the database is first >> launched, how could it have generated duplicate values? >> >> >> Is there an option to get 4D to re-generate the primary key field again >> for that table? >> >> Failing that, is there an option to instruct 4D to ignore and not track >> those tables? >> Thanks >> >> Regards, >> Ronnie >> >> >> ********************************************************************** >> 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] >> ********************************************************************** > > > > > -- > Kirk Brooks > San Francisco, CA > ======================= > > *The only thing necessary for the triumph of evil is for good men to do > nothing.* > > *- Edmund Burke* > ********************************************************************** > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************

