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 <mtmigs@...> 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]