case in calculated field

Article View: borland.public.interbase.sql

Article #563

Back to borland.public.interbase.sql Previous Next

#563

From: Moore
Date: Sun, 30 Sep 2007 14:34

10 lines
1125 bytes

is it posible to include case in the sql of a calculated field? is yes 
then why this does not function :

case TOTAl_ALB
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

TOTAl_ALB is the calculated field
CON_REQ and IVA_INC are other fields in the same table

Technical Details

Message-ID: <46ffb40b$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,2632d4f685f2ef38,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 30 Sep 2007 16:34:46 +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: case in calculated field
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 83.63.210.111
Message-ID: <46ffb40b$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1191162891 83.63.210.111 (30 Sep 2007 07:34:51 -0700)
Lines: 10
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail