Re: Change a field name that is a reserved word

Article View: borland.public.interbase.sql

Article #407

Back to borland.public.interbase.sql Previous Next

#407

From: Karol Bieniaszewski
Date: Mon, 03 Mar 2008 07:30

33 lines
1912 bytes

Uzytkownik "Scott Leake" <sleake@gmail.com> napisal w wiadomosci 
news:C3ECB1D8.8242%sleake@gmail.com...
> On 2/27/08 9:38 PM, in article 47c61ec2$1@newsgroups.borland.com, "Jeff
> Overcash (TeamB)" <jeffovercash@mindspring.com> wrote:
>
>> 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?
>
> Scott


you ommit one word "column"
this statement should by
ALTER TABLE footage ALTER COLUMN "PERCENT" TO pct;

Karol Bieniaszerwski

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!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: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
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: Mon, 3 Mar 2008 08:30:37 +0100
Lines: 36
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
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.205.151.58
Message-ID: <47cba7be@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1204529086 195.205.151.58 (2 Mar 2008 23:24:46 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1761

Reply to Parent Message