Thanks. This is what happens when you work 18 hours non-stop. You start making silly errors.
On Thu, Feb 7, 2013 at 6:59 PM, Ted Miglautsch <[email protected]> wrote: > You are missing the matching ")" right before the ";". After "VALUES" > you have a "(". That needs a matching ")". > > Mags Phangisa wrote: > > > > Can someone please tell me what I am missing here? I just can't see what > > the problem is. > > > > insert into > > > CTDC(CPYNO,CENNO,CONNO,REGDT,GRADE,GRDDT,STTUS,CPTUS,CIPDT,TAXDT,COIDT,BELVL,NHBDT) > > > VALUES('1','11','2','2012-12-05','1','2012-12-05','Active','Registered','2013-02-22','2013-02-28','2013-05-15','4','2013-02-14'; > > *Warning*: ibase_query() > > [function.ibase-queryhttp://localhost/SCI/function.ibase-query>]: > > Dynamic SQL Error SQL error code = -104 Unexpected end of command - > > line 1, > > column 212. > > > > Please note that column 212 is the apostrophe (') after the last comma > > separating the last two column values which are '4' and '2013-02-14'. > > > > I am at my wits end as I don't see the problem. > > > > In case the following is relevant: > > > > Operating system: Ubuntu 11.10 > > Firebird: 2.5.0.26074 Firebird 2.5 > > Table CTDC columns: > > CPYNO smallint NOT NULL, > > CENNO smallint NOT NULL, > > CONNO integer NOT NULL, > > REGDT date, > > GRADE char(1), > > GRDDT date, > > STTUS varchar(12), > > CPTUS varchar(12), > > CIPDT date, > > TAXDT date, > > COIDT date, > > BELVL char(1), > > NHBDT date > > > > Regards, > > Mags > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > [Non-text portions of this message have been removed]
