Paul, here’s that code snippet. I found it.
// Ortwin Zilgen code for instantly upgrading primary keys in a post v13 database (Works !) C_LONGINT($i;$P_SIZE) C_TEXT($tableName_t) $fieldName:="pkUUID" $P_SIZE:=Get last table number For ($i;1;$P_SIZE) If (Is table number valid($i)) $tableName_t:=Table name($i) $statement_t:="ALTER TABLE ["+$tableName_t+"] ADD "+$fieldName+" UUID AUTO_GENERATE PRIMARY KEY;" Begin SQL EXECUTE IMMEDIATE:$statement_t; End SQL End if End for ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************