hello, i'm using sapdb 7.3.0. there is a strange behavior with the keyword now.
in statement 'INSERT INTO update_state (begin_time, section, comment) VALUES (NOW, 'somesection', 'somecomment')' the current datetime is insered in the table. statement 'UPDATE update_state SET begin_time = NOW, state = 'COMPLETE' WHERE id = 1' returns with an error 'missing delimiter'. the statement 'UPDATE update_state SET begin_time = NOW(), state = 'COMPLETE' WHERE id = 1' does the correct update. can anybody tell me why i can't use NOW in update statements? thank you -- freundliche Gr�sse Klaus Dicks Organisationsprogrammierer -- SHD Datentechnik GmbH, Bereich MHS, Rennweg 60, 56626 Andernach Telefon (0 26 32) 2 95-685 Fax (0 26 32) 2 95-488 mailto:[EMAIL PROTECTED] http://www.shd.de _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
