Article View: borland.public.interbase.sql
Article #487Re: Deal with a field called ACTION
From: Martijn Tonies
Date: Thu, 06 Dec 2007 11:13
Date: Thu, 06 Dec 2007 11:13
26 lines
1930 bytes
1930 bytes
> > Yes and the decision to move to FB was not mine or ours, but of the > > company that supplies > > our clinical software, iSoft or now IBA. > > > > Quinn was pointing out you have the same problem in FB as you do in InterBase. > The keyword was added in IB 6.0 so exists in FB also. In addition to Thomas' answers, the Firebird project had some reserved words "demoted" to "keywords", this means you can still use them in column names without having to quote them. So the lists of reserved words are no longer the same. -- 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:
<4757d932$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4755c63a$1@newsgroups.borland.com> <47565c82$1@newsgroups.borland.com> <47571387$1@newsgroups.borland.com> <47571b68$1@newsgroups.borland.com> <47573fe8$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 From: "Martijn Tonies" <m.tonies@upscene.removethis.com> Newsgroups: borland.public.interbase.sql References: <4755c63a$1@newsgroups.borland.com> <47565c82$1@newsgroups.borland.com> <47571387$1@newsgroups.borland.com> <47571b68$1@newsgroups.borland.com> <47573fe8$1@newsgroups.borland.com> Subject: Re: Deal with a field called ACTION Date: Thu, 6 Dec 2007 12:13:28 +0100 Lines: 28 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: <4757d932$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1196939570 212.238.159.172 (6 Dec 2007 03:12:50 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail