Default PK GUID

Posts   
 
    
Posts: 34
Joined: 08-Nov-2007
# Posted on: 06-Dec-2007 11:50:38   

My table Person have a PK called PersonId which is uniqueidentier, not null, rowguid - true, and a default value of newsequentialid().

When I try to save a record using self-service 2.5 llblgen complains that PersonId can not be null, however dont want to generate the guid in my code but have sql do that.

Is there an option I have to enable?

Posts: 34
Joined: 08-Nov-2007
# Posted on: 06-Dec-2007 12:04:28   

My bad again.. SQL SSMEX throws a validation error if you use newsequential, without reading this I clicked Yes (presuming it would force it), however the actual question is do you want to remove the change or something to that effect.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 06-Dec-2007 14:18:11   

simple_smile