UniqueIdentifier as Id column

[Zero-G.]

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

[alexa]

Could you please let us know whether you were referring to Data Editor? Screenshots would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom

[alexa]

Please use the correct string:

Code: Select all

id UNIQUEIDENTIFIER NOT NULL DEFAULT (newsequentialid())

instead of:

Code: Select all

id UNIQUEIDENTIFIER NOT NULL DEFAULT ('newsequentialid')