Deal with a field called ACTION

Article View: borland.public.interbase.sql

Article #474

Back to borland.public.interbase.sql Previous Next

#474

From: RB Smissaert
Date: Tue, 04 Dec 2007 21:27

8 lines
1293 bytes

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: <4755c63a$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,b83ec6715cbbb704,start
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
Subject: Deal with a field called ACTION
Date: Tue, 4 Dec 2007 21:27:14 -0000
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain;
 format=flowed;
 charset="iso-8859-1";
 reply-type=original
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: <4755c63a$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196803642 82.37.28.137 (4 Dec 2007 13:27:22 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail