| Subject | Updating Null Column values Will Raise an Exception -605 |
|---|---|
| Author | sfsyseu |
| Post date | 2012-09-11T18:32:37Z |
ENDDATE is date and was created after the table being created and it allows nulls so it filled the colum with nulls.
So i want to set ENDDATE then i do :
UPDATE MYTABLE
SET ENDDATE=CURRENT_DATE
WHERE MYID=1
Error -605 ???? ****value null****
This wasnt supposed to happen ? It should Set RowID MYID primarykey ENDDATE with the CURRENT_DATE .The problem yet is in the IBOConsole and My Application Components if i change it manualy it accepts it with no problem only Update Query Problem ? So client Drivers dot use Sql ?
I dont undestand wheres the problem.
So i want to set ENDDATE then i do :
UPDATE MYTABLE
SET ENDDATE=CURRENT_DATE
WHERE MYID=1
Error -605 ???? ****value null****
This wasnt supposed to happen ? It should Set RowID MYID primarykey ENDDATE with the CURRENT_DATE .The problem yet is in the IBOConsole and My Application Components if i change it manualy it accepts it with no problem only Update Query Problem ? So client Drivers dot use Sql ?
I dont undestand wheres the problem.