Subject Is start a reserved word?
Author Lars Sandmark
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.

Can anyone help?

Thanks
Lars



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