Re: Deal with a field called ACTION

Article View: borland.public.interbase.sql

Article #477

Back to borland.public.interbase.sql Previous Next

#477

From: Quinn Wildman (CodeGear Develope...
Date: Wed, 05 Dec 2007 04:49

13 lines
1427 bytes

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
>

Technical Details

Message-ID: <47562de3$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!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
Date: Tue, 04 Dec 2007 20:49:37 -0800
From: "Quinn Wildman (CodeGear Developer Support)" <qwildman@nospam.codegear.com>
User-Agent: Thunderbird 1.5.0.13 (Windows/20070809)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Deal with a field called ACTION
References: <4755c63a$1@newsgroups.borland.com>
In-Reply-To: <4755c63a$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.143.100.209
Message-ID: <47562de3$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196830179 10.143.100.209 (4 Dec 2007 20:49:39 -0700)
Lines: 13
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message