Either

use CURRENT_TIME instead of NOW,

or

use CAST('NOW' AS TIMESTAMP) instead of NOW

and put a semi on the end


Roger Vellacott
Passfield Data Systems Ltd
Kingston House,
Pierrepont Street,
Bath,
BA1 1LA
UK
Tel +44 1225 317202

-----Original Message-----
From: Daniel Bertin [mailto:danielb@...]
Sent: 29 July 2003 18:02
To: firebird-support@yahoogroups.com
Subject: [firebird-support] SQL Help please


Can Someone tell me what is wrong with this simple statement? Please

INSERT INTO FEATURES
(TITLE,DESCRIPTION,PRIORITY,DATECREATED,CREATEDBY,PARENTFEATURE,IMPLEMENTEST
IMATE,IMPLEMENTACTUAL,OWNER)

VALUES ('Test Title', 'Test Description', 2 ,NOW, 'me of
course','', 24, 22, 'ownerid')

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command


what is causing this error ?
Daniel





Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=17051153
86:HM/A=1663535/R=0/SIG=11ps6rfef/*http://www.ediets.com/start.cfm?code=3050
4&media=atkins> click here

<http://us.adserver.yahoo.com/l?M=194081.3551198.4824677.1261774/D=egroupmai
l/S=:HM/A=1663535/rand=195429415>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]