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 functionality. I want to change the Field from text to string and make it a primary key and UUID and auto assigned. I found and have used code to add this field for tables where I never installed this field, but I do not know enough SQL to be able to modify an existing field. Can anyone help? Thanks --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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] **********************************************************************

