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]
>
>