Article View: borland.public.interbase.sql
Article #569Re: case in calculated field
From: Moore
Date: Wed, 03 Oct 2007 13:37
Date: Wed, 03 Oct 2007 13:37
19 lines
1331 bytes
1331 bytes
that's it, the error was the missing "end" Maxim Shiryaev escribi๏ฟฝ: > Wrog syntax. > > It should be > > alter table YOUR_TABLE > add TOTAl_ALB integer > computed by > ( > case > when (IVA_INC = 1) then 1 > when (IVA_INC = 1) and (CON_REQ = 0) then 2 > when (IVA_INC = 0) and (CON_REQ = 1) then 3 > end > ) > > Maxim.
Technical Details
Message-ID:
<47039b02@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<46ffb40b$1@newsgroups.borland.com> <47009a84@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,2632d4f685f2ef38 X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII Date: Wed, 03 Oct 2007 15:37:00 +0200 From: Moore <delfino03@caramail.com> User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: case in calculated field References: <46ffb40b$1@newsgroups.borland.com> <47009a84@newsgroups.borland.com> In-Reply-To: <47009a84@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 193.153.21.93 Message-ID: <47039b02@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1191418626 193.153.21.93 (3 Oct 2007 06:37:06 -0700) Lines: 20 Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail