RE: v13 - SQL - how to mdofiy existing field?

2017-02-23 Thread Timothy Penner via 4D_Tech
If the field is set as an Alpha field then you could activate the "Auto UUID" option with this code: Begin SQL ALTER TABLE Table_1 MODIFY uidField ENABLE AUTO_GENERATE; End SQL You could also set that field to the primary key using this code: Begin SQL ALTER TABLE Table_1 ADD PRIMARY KEY(

v13 - SQL - how to mdofiy existing field?

2017-02-23 Thread Chip Scheide via 4D_Tech
I created, in v12 a number a field in a number of tables ' journal_key' which was/is to be the UUID field for journaling. It was/has never been populated. When I created the field in v12 I did not want to fight with the UUID issues present. Now, in v13 I am looking to implement this functionali