Re: debug stored procedures

Article View: borland.public.interbase.sql

Article #344

Back to borland.public.interbase.sql Previous Next

#344

From: Isaac
Date: Tue, 20 May 2008 22:24

10 lines
1725 bytes

Here we go

I tried to make it like this
SUM(COALESCE(QTY, cast(0 AS FLOAT)))

and get this error
data type not supported for arithmetic.!!

it seems SUM can not be used with COALESCE which is very insufficiency 
situation , another bug ???

Technical Details

Message-ID: <48334f8a@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<4831f162@newsgroups.borland.com> <4831f280@newsgroups.borland.com> <4831f42a@newsgroups.borland.com> <483201d3$1@newsgroups.borland.com> <48321ed5$1@newsgroups.borland.com> <4832c323@newsgroups.borland.com> <4832cc01@newsgroups.borland.com> <4832d6a0$1@newsgroups.borland.com> <4832e3e1@newsgroups.borland.com> <4832e64f$1@newsgroups.borland.com> <4832f208$1@newsgroups.borland.com> <4833237c@newsgroups.borland.com> <483328da$1@newsgroups.borland.com> <48332f73@newsgroups.borland.com> <483334b2$1@newsgroups.borland.com> <48333a8e@newsgroups.borland.com> <4833427b@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,8feff649be448d0
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 21 May 2008 01:24:01 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: debug stored procedures
References: <4831f162@newsgroups.borland.com> <4831f280@newsgroups.borland.com> <4831f42a@newsgroups.borland.com> <483201d3$1@newsgroups.borland.com> <48321ed5$1@newsgroups.borland.com> <4832c323@newsgroups.borland.com> <4832cc01@newsgroups.borland.com> <4832d6a0$1@newsgroups.borland.com> <4832e3e1@newsgroups.borland.com> <4832e64f$1@newsgroups.borland.com> <4832f208$1@newsgroups.borland.com> <4833237c@newsgroups.borland.com> <483328da$1@newsgroups.borland.com> <48332f73@newsgroups.borland.com> <483334b2$1@newsgroups.borland.com> <48333a8e@newsgroups.borland.com> <4833427b@newsgroups.borland.com>
In-Reply-To: <4833427b@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.198.61
Message-ID: <48334f8a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211322250 41.234.198.61 (20 May 2008 15:24:10 -0700)
Lines: 10
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message