Reserved words & fields name in Interbase

[Giancarlo]

I'm translating a Microsoft SQLServer database on an Intrebase database and I have some difficulties on fields such as: password, auto, position. These fields name are not allowed in Interbase because you can't use a keyword for name of a fields.
How can I do?
Tankyou for your answers,
Giancarlo

 

[cerrog]

I had the same problem when converting from mySQL, I finally resign to rename the columns that were in conflicts with Interbase's reserved words. Sorry :-(

 

[SpenBabe]

Not much help I know, but if you have to keep same names you can quote them in the table definition.

For example:-

CREATE TABLE MYTABLE (
CODE CHAR(10) NOT NULL,
"PASSWORD" CHAR(20),
.....
)

But watch out if you going to use 3rd party software to access the data through ODBC. We use Easysoft's ODBC driver to connect through to our own software, Microsoft Query & Seagate Crystal Reports. MS Query does not like the reserved words at all (quoted or not), so we had to bite the bullet & rename the columns !!
Spencer Window (not a joke name)
spencer.window@eastmidlandcomputers.ltd.uk