It was the bracket. My brain is toast, too tired.

On Thu, Feb 7, 2013 at 7:04 PM, Parzival <parzival1969@...> wrote:

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


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