Hello,



is the closing braket missing? Or is it a typo in the email?



Niko



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','201
3-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]





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