Subject | Is start a reserved word? |
---|---|
Author | Lars Sandmark |
Post date | 2009-05-05T05:09:40Z |
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]
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]