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.