StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Error in Insert (Save)

Error in Insert (Save)

Angela Sampaio — Tue, 13 May 2008 09:36:04 GMT

Hi,

I have a BO of products that contains a field pro_nrow; this field is the Primary Key and the "Auto Incrementing" is enabled (Seed 1, Increment 1).

When I try save a product, appears a error message

[b]Unable to enter an explicit value for the identity column of the table 'tabproduto' when IDENTITY_INSERT is set to OFF.[/b]

When I insert directly into a database gives certain.

I looked debug.html the file and noticed that he is going empty ('') for the pro_nrow.
Is attached the image of debug.html

Thank you.

RE: Error in Insert (Save)

Trent L. Taylor — Tue, 13 May 2008 09:36:04 GMT

Good to hear you found your problem.

RE: Error in Insert (Save)

Greg McGuffey — Mon, 12 May 2008 14:10:00 GMT

Glad you found it!

RE: Error in Insert (Save)

Angela Sampaio — Mon, 12 May 2008 13:39:09 GMT

Hi Greg,

I find the problem ...
In the "ProdutoBO.cs" file the properties were set correctly, but in the form of product the BO "sysProdutoBO1" the property PrimaryKeyIsAutoIncremented was as false.

Now is correctly.
Thanks!

RE: Error in Insert (Save)

Angela Sampaio — Mon, 12 May 2008 13:19:36 GMT

Yes, the BO is setup correctly...
I don't know what more can be causing this problem...

RE: Error in Insert (Save)

Greg McGuffey — Mon, 12 May 2008 12:47:09 GMT

Is the BO setup correctly? It should be setup (in the CRUD settings area) with PrimaryKeyIsAutoIncremented=True, PrimaryKeyIsUpdatable=False and the field that is the PK should be shown as the PK in the BO Mapper (which will set that field as the PK when you build the BO).