Error adding new record...


Author
Message
StarkMike
StarkMike
StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)
Group: Forum Members
Posts: 436, Visits: 944
Everytime I try to add a new record I get this error...



Cannot insert the value NULL into column 'id', table 'BluePrintLog.dbo.BPLBluePrints'; column does not allow nulls. INSERT fails. The statement has been terminated.



I'm not sure why.



Any ideas?
StrataFrame Team
S
StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
What's the data type of the 'id' column, what is the PrimaryKeyIsAutoIncremented property value on your business object, and is the column an IDENTITY column?
StarkMike
StarkMike
StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)StrataFrame User (498 reputation)
Group: Forum Members
Posts: 436, Visits: 944
Problem solved. It wasn't set to be an identity column. i guess the upgrade wizard left that part out. ;-)

Thanks.

StrataFrame Team
S
StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Glad you got it working Smile
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search