paone@u2.rutgers.edu (Sarge) (04/28/88)
First, thanks to all the responded to my previous question. Now, one more question that I need an answer on. Has anyone ever experienced a -1225 error? I called the informix hotline several months ago, and they thought I made a mistake. Now, on a program that has been in service for 4 months, the error popped up again. The user had to enter and exit the application, then tried te same sequence eof commands and it worked fine. I am using ESQL version 2.10.00A. All replies appreciated, Phil Paone -- Phil Paone paone@topaz.rutgers.edu "Admiral...There be whales here"
aland@infmx.UUCP (Dr. Scump) (05/11/88)
In article <Apr.27.16.37.33.1988.2250@u2.rutgers.edu>, paone@u2.rutgers.edu (Sarge) writes: > > First, thanks to all the responded to my previous question. Now, one > more question that I need an answer on. Has anyone ever experienced a > -1225 error? I called the informix hotline several months ago, and > they thought I made a mistake. Now, on a program that has been in > service for 4 months, the error popped up again. The user had to > enter and exit the application, then tried te same sequence eof > commands and it worked fine. > Error -1225 means "Column does not admit a NULL value". It is very strange to get something like this intermittently - it's a pretty straightforward error. It only results when you are trying to INSERT a row in which either a column defined as NOT NULL is about to get a null value or the column is omitted from the column list (omission implies that null is to be used for that column). It will also happen if you try to UPDATE a column defined as NOT NULL with a null value. Perhaps in these situations, a user had given a null for a host variable value that is normally present and was later used in an INSERT or UPDATE statement. -- Alan S. Denney | Informix Software, Inc. | {pyramid|uunet}!infmx!aland CAUTION: Objects on terminal are closer than they appear... Disclaimer: These opinions are mine alone. If I am caught or killed, the secretary will disavow any knowledge of my actions.