2. ASPRunnerPro General questions
  3. Ms Sql - Id autonumber
This topic is locked

Ms Sql - Id autonumber

 		12/8/2006 11:21:14 PM
ASPRunnerPro General questions
N
 nitnelav21 author

I make a simply program in sql, but the system say [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ID', table 'nitnela_llamadas.nitnela_valentin.llamadas'; column does not allow nulls. INSERT fails.
Somebody can tell me what happen, I added a picture (please visit

J
 		Jane 12/11/2006

Hi,
This error means that you try to insert null value to the ID column.
I recommend you to change type of this field (ID) to auto-increment in the database or check off this field on the LIST page on the Choose fields tab in the ASPRunnerPro.
N
 		nitnelav21 author 12/11/2006

Hi,

This error means that you try to insert null value to the ID column.
I recommend you to change type of this field (ID) to auto-increment in the database or check off this field on the LIST page on the Choose fields tab in the ASPRunnerPro.
N
 		nitnelav21 author 12/11/2006




How can I put auto-increment in field (id)
J
 		Jane 12/12/2006

You can set up id field to auto-increment in your database directly.

Just select auto-increment in the Data type column for the ID field.