Problem with adding new row

[Hien Khieu]

Hi everyone,

I am having problem with add new row to a table that have primary key as autoincrement number. The app keeps return exception with the message that "DEFAULT or NULL are not allowed as explicit identity values.". Anyone has any idea.

Thanks.

[Aikiken]

I have aquestion here too and I hope someone answers it faster then your was answered...

Any way, I think what may be happenning to you is that you are trying to create a child record independently.

The way that works is this:

Parent Record I will name PR for the sake of excersize,

myBiz.childRecord CR = PR.NewChildRecord();

//Then you can add it's other attributes as you need to.

CR.field = "content";

and finally:

DataManager.CommitAll();

I hope this helps.

Aikiken

[Caleb]

That error was happening with SQL 2005 because the identity columns were not identified correctly. There is a fix in the help forum.