Peter Jakobsson writes: >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 Do you happen to know whether this will cause the On Saving Existing Record Event Trigger Event to occur? Tom Benedict Optum This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ********************************************************************** 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] **********************************************************************
