CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

 Insert and Primary Key Problem

Print topic Send  topic

Author Message
Mario

Posts: 14
Posted: 03/15/2012, 8:45 AM

Hello,
using ccs 4.3, sql server, VB.net (aspx) and IIS

I have a page with a record grid. I have set it up (in the builder) to "Autoincrement Primary key" in the first screen, and set the "id" field to be the primary key.

I finish the builder and test the page (IIS).

When I hit the button to add up a new record (once the form is filled), I get an error message (something like, I am translating from Spanish):

"Se termin� la instrucci�n. No se puede insertar el valor NULL en la columna 'Id', tabla 'table_whatever'. La columna no admite valores NULL. Error de INSERT"

"Instruction end. It is not possible to insert a NULL value into the column "id", table 'table_whatever'. The column does not admit NULL values. INSERT error"

That "id" field in the SQL table is set to "int" and to be a primary key with no null values allowed.

I guess it is gotta be something easy to fix but....I have spent some time without luck.

Any tip to set me to the right direction?

Thanks in advance.
View profile  Send private message
DataDoIT
Posted: 03/15/2012, 11:46 AM

Check to make sure the field is set to Auto Increment in the database
schema.
Mario

Posts: 14
Posted: 03/16/2012, 1:34 AM

:-D

<!--WORKS-->

Thanks for your help!!
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.