Subject Re: [firebird-support] Reserved word : PARAMETER?
Author Helen Borrie
At 12:19 AM 21/04/2006, you wrote:
>Tried to create a table like (in ver 2.0):
>
>CREATE TABLE notification (
> ID NUMERIC(18,0) NOT NULL,
> SCHEME NUMERIC(18,0),
> EVENT VARCHAR(56),
> EVENT_TYPE_ID NUMERIC(18,0),
> TEMPLATE_ID NUMERIC(18,0),
> TYPE VARCHAR(56),
> PARAMETER VARCHAR(56),
> CONSTRAINT PK_notification
> PRIMARY KEY (ID)
> )
>
>But this failed on the 'PARAMETER' column and I can see that IB
>Express hilights the word as if it were reserved.
>
>Is 'PARAMETER' reserved?

Yes. If you want to use it anyway, define it inside double-quotes.

./heLen