Re: Deal with a field called ACTION

Article View: borland.public.interbase.sql

Article #475

Back to borland.public.interbase.sql Previous Next

#475

From: WillR
Date: Thu, 06 Dec 2007 04:01

11 lines
1340 bytes

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
> 
Use Quotes ... "ACTION" ???

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.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: Wed, 05 Dec 2007 21:01:35 -0700
From: WillR <willrNo.Spam.pmccl.noSpam.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
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: 189.174.204.92
Message-ID: <47562299$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196827289 189.174.204.92 (4 Dec 2007 20:01:29 -0700)
Lines: 11
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.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