BUG: Cannot Insert Values with Visual J++ Data Form Application (201557)
The information in this article applies to:
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.
STATUSMicrosoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug kbDSupport KB201557 |
|---|
|