Update giving (null values not allowed)

[dledbetter@adeleknits.com]

To whom it may concern: I have an Interactive SQL that I ran for this file. Because this is company specific, I ran it for TE. It worked. Now, when I run the same SQL except change the TE to AK, I get the following. I checked the AKIMp100 file and the Msrtehdr file for nulls with SQL. It did not show me any records. So, I'm stuck and lost. Thanks for your assistance in advance. Derek

---

Code

[K.Forsythe]

Update giving (null values not allowed)

The problem is not NULL data in the table. Its a sub select that returns no data. You are setting a.eqty20= (nothing), that is the error. Use a coalesce function to provide an alternative default value if the subselect returns a NULL. See the sample below. This will use the result of the sub select, unless it is NULL. Then, the 0 is used instead. If 0 is the wrong default value, change to whatever is correct. Have fun!

---

Code