Microsoft KB Archive/170765

= PRB: Unable to Insert Record into Table Using Form Wizard =

Article ID: 170765

Article Last Modified on 5/2/2006

-

APPLIES TO


 * Microsoft Visual InterDev 1.0 Standard Edition

-



This article was previously published under Q170765



SYMPTOMS
When you try to use the Form Wizard on a SQL Server table without including the primary key field or a field with its Identity column checked (and without setting the Identity Seed and Identity Increment properties to valid values), you receive the following error message after you click Insert:

Unable to insert the record into.

Source: Microsoft OLE DB Provider for ODBC Drivers

Error Number: -2147467259

Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The column in table. may not be null. This may be caused by an attempt to update a non-primary table in a view.



CAUSE
When you try to update a table with a new record, the primary key and index field must have a valid non-null value. If the primary key or index field does not have its Identity column, Identity Seed, and Identity Increment fields set, the update generates an error. The Seed and Increment fields must be set, after which the primary key is automatically updated with an auto-increment value whenever the table is updated with a new record.



RESOLUTION
From within either Visual InterDev or SQL Enterprise Manager, set the Seed value and Increment value to a valid value.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
SQL 6.5 Server Table:
 * 1) In Data View, right-click Tables, and then click New Table. Name the table customers.
 * 2) Create the following three fields: custID(int, Not Null, primary key), fname(varchar(15), Not Null), lname(varchar(15), Not Null).
 * 3) Use the Data Form Wizard to create a form based on the customers table.
 * 4) Select all fields to be included in the form except the custID field.
 * 5) Preview the xxxform.asp. Click New, type data into the fields, and then click Insert.

