General information
Category:
Coding, syntax & commands
Title:
Null Value error while updating table
Hi,
trying to update table using UPDATE-SQL and keep getting an error, that field "grno" doe snot accept NULL value.
First of all, it happens only when I run EXE, never in APP. and second, I am using NVL function to prevent any NULLs.
Please see the simple code below:
UPDATE PS1;
SET PS1.grno=NVL(ID.grno,SPACE(6)) ;
FROM PS1 ;
LEFT OUTER JOIN ID1 ON UPPER(PS1.employeeid)=UPPER(ID1.employeeid)
I tried to use INNER JOIN, but received the same error message.
And by the way, I modified the table PS1 to allow NULL value in the field "grno".
Any ideas?
Thanks
Jerry
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only