Sorry I disagree create new key fields in v15 with empty data file just don't use built in stuff roll your own. Then when you open real data file all will work as expected. You can not make type of uuid before v15 as far as I know
Regards Chuck Sent from my iPhone > On Oct 24, 2017, at 6:22 PM, Ronnie Teo via 4D_Tech <[email protected]> > wrote: > > Hi Arnaud, > > Thanks for your reply. > I think my mistake was in not launching the v15 structure with an empty data > file first because it converted a test data file well. > > Before v15, it was a mix of field types, some tables had an alpha string, > some had long integers, some tables need not have unique keys. > My intention is not to change relations as they are working now but merely to > use 4D’s primary ket feature for journaling purposes down the road. > > My immediate idea is to use the Generate UUID command to loop through the > records in the few affected tables and let them re-generate the UUID field > again. > Hope this will work. > > Regards, > Ronnie > > > > >> On 25 Oct 2017, at 3:00 am, [email protected] wrote: >> >> From: Arnaud de Montard <[email protected] <mailto:[email protected]>> >> To: 4D iNug Technical <[email protected] <mailto:[email protected]>> >> Subject: Re: Primary Key in 4Dv15 >> Message-ID: <[email protected] >> <mailto:[email protected]>> >> Content-Type: text/plain; charset=utf-8 >> >> >>> Le 24 oct. 2017 à 11:49, Ronnie Teo via 4D_Tech <[email protected] >>> <mailto:[email protected]>> a écrit : >>> >>> Hi All, >>> >>> Need to seek some advice in converting a client’s database from v11 to v15. >> >> I follow what others said: generate the unique key _before_ v15, even if it >> means a 2-steps migration (v11 -> v[between 11 and 14] -> v15). Not to say >> the assistant is good or bad, but to avoid surprises when migrating in >> production. >> >> In v15 a primary key (PK) is mandatory, but it does not mean the PK must be >> of UUID type. A uuid is better for the future but changing relations based >> on PK/FK in a given datatype to another is not a little job… >> >> What kind of field type do you already use for the existing relations in >> v11? >> >> -- >> Arnaud de Montard > > ********************************************************************** > 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] **********************************************************************
