Article View: borland.public.interbase.sql
Article #15Re: debug stored procedures
From: Wayne Niddery (TeamB)
Date: Wed, 21 May 2008 15:47
Date: Wed, 21 May 2008 15:47
20 lines
2433 bytes
2433 bytes
"Isaac" <no@no.com> wrote in message news:48334f8a@newsgroups.borland.com... > > 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 ??? I just tried and SUM can definitely work fine with Coalesce. Something else is wrong. Check the version of your database, if it has been converted from an older version, perhaps that is causing a problem. It may be the database has to be version 12 and dialext 3. -- Wayne Niddery - TeamB (www.teamb.com) Winwright, Inc. (www.winwright.ca)
Technical Details
Message-ID:
<48344401@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<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> <48334f8a@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 From: "Wayne Niddery \(TeamB\)" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.interbase.sql 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> <48334f8a@newsgroups.borland.com> In-Reply-To: <48334f8a@newsgroups.borland.com> Subject: Re: debug stored procedures Date: Wed, 21 May 2008 11:47:13 -0400 Lines: 21 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Windows Mail 6.0.6001.18000 x-mimeole: Produced By Microsoft MimeOLE V6.0.6001.18000 NNTP-Posting-Host: 24.137.214.213 Message-ID: <48344401@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1211384833 24.137.214.213 (21 May 2008 08:47:13 -0700) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail X-Original-Bytes: 2269