|
| Re: Deal with a field called ACTION |
 |
Tue, 04 Dec 2007 20:49:37 -080 |
With InterBase 5.6 - no. With InterBase 6.0 are later you can use
delimited identifiers.
RB Smissaert wrote:
> We have a large table that holds audit data for a medical database.
> Unfortunately the field that holds the value for the action taken
> (update, insert, delete etc.) was called ACTION.
> As this is a reserverd keyword in Interbase 5.6 (and maybe higher) doing
> a select or where on this field causes
> an error. Is there any way round this other than altering the table?
>
> RBS
|
| Post Reply
|
| Re: Deal with a field called ACTION |
 |
Tue, 04 Dec 2007 20:50:32 -080 |
Not with InterBase 5.6. This is delimited identifiers and it was
introduced with InterBase 6.0
WillR wrote:
> RB Smissaert wrote:
>> RBS
>>
|
| Post Reply
|
| Deal with a field called ACTION |
 |
Tue, 4 Dec 2007 21:27:14 -0000 |
We have a large table that holds audit data for a medical database.
Unfortunately the field that holds the value for the action taken (update,
insert, delete etc.) was called ACTION.
As this is a reserverd keyword in Interbase 5.6 (and maybe higher) doing a
select or where on this field causes
an error. Is there any way round this other than altering the table?
RBS
|
| Post Reply
|
| Re: Deal with a field called ACTION |
 |
Wed, 5 Dec 2007 08:08:24 -0000 |
Thanks for the suggestions and it looks we are stuck then.
We will be moving to FB in a few months and with that there is no problem,
so I suppose
we will have to leave it at that.
RBS
"RB Smissaert" <bartsmissaert@blueyonder.co.uk> wrote in message
news:4755c63a$1@newsgroups.borland.com...
> We have a large table that holds audit data for a medical database.
> Unfortunately the field that holds the value for the action taken (update,
> insert, delete etc.) was called ACTION.
> As this is a reserverd keyword in Interbase 5.6 (and maybe higher) doing a
> select or where on this field causes
> an error. Is there any way round this other than altering the table?
>
> RBS
>
|
| Post Reply
|
| Re: Deal with a field called ACTION |
 |
Wed, 05 Dec 2007 13:09:24 -080 |
It should be noted that InterBase 6 and later support this feature the
same as FireBird.
RB Smissaert wrote:
> Thanks for the suggestions and it looks we are stuck then.
> We will be moving to FB in a few months and with that there is no
> problem, so I suppose
> we will have to leave it at that.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|