Re: Deal with a field called ACTION

Article View: borland.public.interbase.sql

Article #478

Back to borland.public.interbase.sql Previous Next

#478

From: RB Smissaert
Date: Wed, 05 Dec 2007 08:08

19 lines
1782 bytes

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
>

Technical Details

Message-ID: <47565c82$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4755c63a$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,b83ec6715cbbb704
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "RB Smissaert" <bartsmissaert@blueyonder.co.uk>
Newsgroups: borland.public.interbase.sql
References: <4755c63a$1@newsgroups.borland.com>
Subject: Re: Deal with a field called ACTION
Date: Wed, 5 Dec 2007 08:08:24 -0000
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain;
 format=flowed;
 charset="iso-8859-1";
 reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 82.37.28.137
Message-ID: <47565c82$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196842114 82.37.28.137 (5 Dec 2007 00:08:34 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message