Gianni
|
| Posted: 08/07/2002, 1:44 AM |
|
Hi,
Using "New Page Wizard" I created Grid+Edit forms for this table:
nr ........ int ... (primary key)
name ...... char
address ... char
The "Key" field for column "nr" is checked both on the grid form and the record form.
The grid form is displayed correctly. So is the edit form, but only for existing records. Infact if I click on "Insert" I get the following error message in the browser window
SQL :select * from PLTDACIRCOLI where INT_CIRCOLO=Null
COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0401N The data types of the operands for the operation "=" are not compatible. SQLSTATE=42818
How do I correct this?
Thank you very much for your help.
Gianni
|
|
|
 |
Gianni
|
| Posted: 08/07/2002, 3:54 AM |
|
Sorry....
the correct error message is:
SQL :select * from PLTDACIRCOLI where INT_NR=Null
COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0401N The data types of the operands for the operation "=" are not compatible. SQLSTATE=42818
Gianni
|
|
|
|
|
