>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
>
try
UPDATE PS1;
SET PS1.grno=NVL(ID.grno,SPACE(6)) ;
FROM PS1 ;
LEFT OUTER JOIN ID1 ON UPPER(PS1.employeeid)=UPPER(ID1.employeeid)
WHERE NVL(ID.grno,SPACE(6)) IS NOT NULL
the error is still present ?