BUG: Cannot Insert Values with Visual J++ Data Form Application
Article ID: 201557
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft Visual J++ 6.0 Standard Edition
This article was previously published under Q201557
SYMPTOMS
When an application generated by the Data Form Wizard in Visual J++ uses bindings to fields in a table, the following (or similar) error can occur when a new row is being inserted into the table:
Cannot insert the value NULL into column 'column', table 'table'; column does not allow nulls. INSERT fails.
The error message substitutes real names for the column and table.
CAUSE
The error message is generated when any fields that do not allow nulls are excluded from the field list that is bound on the form. Because the values for these fields cannot be provided by the bound controls when inserting, the default null is used for these values in the table and the error message is returned by the database. The Data Form Wizard does not check whether any fields that do not allow nulls are missing from the field list bound on the form.
RESOLUTION
Make sure that all fields that require non-null values are included in the list of bound fields on the form, and provide valid values for these fields when performing an insert.
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Additional query words: kbDSupport
Keywords: kbbug kbpending KB201557