Re: Change a field name that is a reserved word

Article View: borland.public.interbase.sql

Article #403

Back to borland.public.interbase.sql Previous Next

#403

From: Scott Leake
Date: Thu, 28 Feb 2008 23:45

22 lines
1654 bytes

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

Technical Details

Message-ID: <C3ECB1D8.8242%sleake@gmail.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.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>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,12d183e78a7d5da7
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
User-Agent: Microsoft-Entourage/11.4.0.080122
Date: Thu, 28 Feb 2008 18:45:44 -0500
Subject: Re: Change a field name that is a reserved word
From: Scott Leake <sleake@gmail.com>
Newsgroups: borland.public.interbase.sql
Message-ID: <C3ECB1D8.8242%sleake@gmail.com>
Thread-Topic: Change a field name that is a reserved word
Thread-Index: Ach6ZAieRzbcDOZXEdy4/wAWy5+PFw==
References: <C3EB7CF4.80BC%sleake@gmail.com> <47c61ec2$1@newsgroups.borland.com>
Mime-version: 1.0
Content-Type: text/plain;
 charset="US-ASCII"
Content-transfer-encoding: 7bit
NNTP-Posting-Host: 72.84.195.233
X-Trace: newsgroups.borland.com 1204242343 72.84.195.233 (28 Feb 2008 15:45:43 -0700)
Lines: 23
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.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: 1482

Reply to Parent Message