UUID Field

(Dev Manual)


There is a field in each table called UUID. That field is a serial number field particular to that record in that table. It is a result of a custom function named UUID.New (http://www.fmfunctions.com/functions_display_record.php?functionId=274). The result is a combination of the Unix date, a random number, and the MAC address of the computer creating the record.


There are two other functions that are useful here, UUID.GetNICAddress (http://www.fmfunctions.com/functions_display_record.php?functionId=276) which separates the address from the UUID field, and UUID.GetTimeStamp, which pulls the time from the UUID field.


<- Sync Scripts Create Accession Number Script->