Article View: borland.public.interbase.sql
Article #1Re: UNKOWN COLUMN error with CREATE TRIGGER, IB bug?
From: Simon
Date: Thu, 09 Jan 2003 04:52
Date: Thu, 09 Jan 2003 04:52
25 lines
2195 bytes
2195 bytes
Thanks, that worked. "Claudio Valderrama C." <user@domain.invalid> wrote in message news:3e1cfd4b@newsgroups.borland.com... > In news:3e1cfb1c@newsgroups.borland.com, Simon typed: > > I've tried the following DDL on two databases and received the UNKOWN > > COLUMN error both times. IB 6.0, Win2000 SP3 > > Any ideas why? Can't see any misspellings or anything obvious. IB bug? > > > > "FolderID" INTEGER NOT NULL, > > > if (New.FolderID is Null) then New.FolderID = GEN_ID( > > Try New."FolderID" instead. > Otherwise, don't declare you field enclosed in double quotes and avoid the > issue at all. > (I think that only Firebird gives you the name of the unrecognized column > name.) > > C. > -- > Claudio Valderrama C. > www.cvalde.com - www.firebirdSql.org > >
Technical Details
Message-ID:
<3e1cff5b$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3e1cfb1c@newsgroups.borland.com> <3e1cfd4b@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f4565,9bccbe98c578c2cc,start X-Google-Attributes: gidf4565,public X-Google-Thread: fd38c,9bccbe98c578c2cc,start X-Google-Attributes: gidfd38c,public X-Google-Thread: 114a0e,9bccbe98c578c2cc,start X-Google-Attributes: gid114a0e,public X-Google-Thread: ffb43,9bccbe98c578c2cc,start X-Google-Attributes: gidffb43,public X-Google-ArrivalTime: 2003-01-08 21:00:02 PST From: "Simon" <nospam@nospam.com> Newsgroups: borland.public.interbase.sql,borland.public.interbase.general,borland.public.interbase.bugdiscussion,borland.public.interbase.ibconsole References: <3e1cfb1c@newsgroups.borland.com> <3e1cfd4b@newsgroups.borland.com> Subject: Re: UNKOWN COLUMN error with CREATE TRIGGER, IB bug? Date: Thu, 9 Jan 2003 17:52:16 +1300 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 210.55.107.182 Message-ID: <3e1cff5b$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1042087771 210.55.107.182 (8 Jan 2003 20:49:31 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail