Updating Null Column values Will Raise an Exception -605
--------------------------------------------------------
Key: CORE-3920
URL: http://tracker.firebirdsql.org/browse/CORE-3920
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.3
Environment: Windows, Delphi, IBOConsole, AMDTurion X2
Reporter: Sérgio
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 th 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 Query
Problem.
I dont undestand wheres the problem.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
