AutoGUID are not working as expected in smartforms

 

Symptoms

Using the "AutoGUID" smartobject property does not seem to work on a SQL based smartobject.
 

Diagnoses

This was a miss-configuration issue when creating the SQL table. You have to enter "newid()" as the default value if ID field on the table.
 

Resolution

After the SQL table was updated and the smartobject refreshed, all was well.