PRB: Unable to Insert Record into Table Using Form Wizard

• Microsoft Visual InterDev, version 1.0

SYMPTOMS

When attempting 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); the following error is received after clicking the Insert button:

Unable to insert the record into <table name>.
Source: Microsoft OLE DB Provider for ODBC Drivers
Error Number: -2147467259

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

CAUSE

When attempting 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.

MORE INFORMATION

Steps to Reproduce Behavior

1. In Data View right-click Tables and select 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. Select New and enter data into the fields, and click Insert.

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

http://support.microsoft.com/support/vinterdev/

Additional query words:

Keywords          : kberrmsg kbnokeyword kbVisID kbVisID100 kbGrpASP 
Version           : WINDOWS:1.0
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 10, 1999