It would be useful to have a built in function to generate a GUID in a field.
We now have a GUID function that can create new GUIDs.
Check out the GUID function's documentation and the blog post on using GUIDs with CDS and SQL Server.
Agree, in order to build an offline scenario with master and detail we will need one.
For my scenario, it related to SharePoint, where I am trying to create 2 or more items from 1 form (the master and detail). Where SharePoint does not issue an ID to the master item until it has been submitted, and therefore, it is impossible to issue that same parent ID to the detail items until the item has been created. Therefore, we need to create our own ID, and a GUID is the most logical way of doing this.
This seems essential just for creating items in SQL Databases that are going to be synchronised.
I have used this method to create a "GUID" for one of my applications.
Hi - Think that using ticks(utcNow()) is even better as it allows for 10 million unique instances pr. second.
I was just looking for the same functionality for a new app I have been creating. Nice to know I am not alone