>>>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 ?
>
>Thanks. It does not work.
Redefine a new PS1 table.