As is shown in the releasenotes of firebird 2.1 START is reserved from version, see http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb20x-reswords-added

Either rename the field or use quotes to escape it (using select "START" from pass should work).

BTW: Do realise that Firebird 2.5 is still in beta and should not be used in production. Firebird 2.1.2 is the latest stable version.

Mark

> I've just migrated from Firebird 1.03 to Firebird 2.5 and have problems
> with
> tables that have worked fine in 1.03.
> I'm using Flamerobin to manage my database.
>
> I have a couple of tables with Time-fields as the one below
>
> CREATE TABLE Pass
> (PassID integer NOT NULL,
> Brukare varchar(10) NOT NULL,
> PassBet varchar(4),
> Start Time,
> Slut Time,
> CONSTRAINT PK_PASS_PASSID PRIMARY KEY (PassID) );
>
> When I execute the statement
>
> select * from pass
>
> I get the whole table. But when I execute
>
> select passid, start from PASS
>
> Flamerobin says :
> Invalid token
>
> Engine Code : 335544569
> Engine Message :
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, column 16
> start
>
> On the other hand, when I execute
>
> select passid, slut from PASS
>
> everything works fine.
>
> Is start a reserved word? How can I get around this? In my application I
> have hundreds of SQL-questions referring to tables with the fieldname
> start.

--
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss für nur 17,95 Euro/mtl.!* http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a