UniqueIdentifier as Id column
Posted: Tue 14 Jul 2015 11:07
Hey
I use uniqueidentifiers as ID's
There I have 1 Problem and two Little Feature requests.
1) When I insert data through your DataInput Feature, then I get an error, that Id field is not allowed to be NULL. But I have defined the field as follows:
Id UNIQUEIDENTIFIER NOT NULL DEFAULT ('newsequentialid()')
So, the field would be set, if the insert Statement would be send to the Database.
And here Comes the first Feature request:
Please do a refresh of the actual line. - Because then the Id would be set correct & when a Trigger is set to update a field, then this would be displayed imediatley.
Second Feature request: Add the possibilite to generate a GUID from the Set Value Option on right click
THX
I use uniqueidentifiers as ID's
There I have 1 Problem and two Little Feature requests.
1) When I insert data through your DataInput Feature, then I get an error, that Id field is not allowed to be NULL. But I have defined the field as follows:
Id UNIQUEIDENTIFIER NOT NULL DEFAULT ('newsequentialid()')
So, the field would be set, if the insert Statement would be send to the Database.
And here Comes the first Feature request:
Please do a refresh of the actual line. - Because then the Id would be set correct & when a Trigger is set to update a field, then this would be displayed imediatley.
Second Feature request: Add the possibilite to generate a GUID from the Set Value Option on right click
THX