I'm working on a website that will be a webshop in the end. I chosed MSDE as database for the project. Now I have a problem. When i want to have a counter (for the cusomers number for exampel) i can't turn autoincresement on. Well I can, but I can't save it. If i try I get an errormessage.
Why is it so and how will i get it to work?
I'm running the newest version...
Thanks for any help!What is the error message you are receiving?
In order to make a column an Identity column the data type must be integer and it may not allow nulls.
Terri|||I have translated the errormessage from swedish to english. I don't think it's absolutley correkt translated but i hope you will understand it anyway:
(And yes i have the column as Int and not allow nulls)
There was an error saving the design of this table. No changes were made.
[Microsoft][ODBC SQL server driver][SQL server] Unable to create standardvalue on colums with IDENTITY-attribut. Tabel 'tbkunder', column 'kundnummer.
[Microsoft][ODBC SQL server driver][SQL server] Unable to create restriction. Watch previous errormessage.|||This is very difficult with the language difference.
It sounds to me like you are trying to set the IDENTITY property on a column that has a Default Value set, which can't be done.
Terri
No comments:
Post a Comment