Re: Change a field name that is a reserved word

Article View: borland.public.interbase.sql

Article #405

Back to borland.public.interbase.sql Previous Next

#405

From: Martijn Tonies
Date: Fri, 29 Feb 2008 09:14

34 lines
1888 bytes

> > You need to double quote the reserved words.  Remember this makes it
case
> > sensitive so make sure the column is all caps.
>
> The two columns I am dealing with are PERCENT and TYPE.  In IBConsole,
using
> Interactive SQL, I put in this statement:
>
> ALTER TABLE footage ALTER "PERCENT" TO pct;
>
> I get back:
>
> SQL error code = -104
> Token unknown - line 1, char 26
> "PERCENT"
>
> There is definitely a column named PERCENT.
>
> Any thoughts?

What is the connection dialect?

I think you need to use dialect 3 to use delimited identifiers.

-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Technical Details

Message-ID: <47c7cc94@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!eweka.nl!lightspeed.eweka.nl!194.134.4.77.MISMATCH!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <C3EB7CF4.80BC%sleake@gmail.com> <47c61ec2$1@newsgroups.borland.com> <C3ECB1D8.8242%sleake@gmail.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,12d183e78a7d5da7
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Martijn Tonies" <m.tonies@upscene.removethis.com>
Newsgroups: borland.public.interbase.sql
References: <C3EB7CF4.80BC%sleake@gmail.com> <47c61ec2$1@newsgroups.borland.com> <C3ECB1D8.8242%sleake@gmail.com>
Subject: Re: Change a field name that is a reserved word
Date: Fri, 29 Feb 2008 10:14:19 +0100
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: 212.238.159.172
Message-ID: <47c7cc94@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1204276372 212.238.159.172 (29 Feb 2008 01:12:52 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!eweka.nl!lightspeed.eweka.nl!194.134.4.77.MISMATCH!news2.euro.net!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