Re: debug stored procedures

Article View: borland.public.interbase.sql

Article #45

Back to borland.public.interbase.sql Previous Next

#45

From: Wayne Niddery (TeamB)
Date: Fri, 23 May 2008 16:22

14 lines
2398 bytes

"Isaac" <no@no.com> wrote in message news:4836d44c@newsgroups.borland.com...
>
> oh I forget to tell you that I store the return value into a float 
> variable
>
> select sum(coalesce(qty2)) from test_data into :qty_sum  <<<- float var

I would think an integer value should be assignable to a float value, but 
perhaps not, I've not tried it. So make qty_sum an integer value instead - 
sums of integers are always going to be integers anyway.

-- 
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca)

Technical Details

Message-ID: <4836ef59$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!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> <48334f8a@newsgroups.borland.com> <48344401@newsgroups.borland.com> <483457ca@newsgroups.borland.com> <48360564$1@newsgroups.borland.com> <4836d206@newsgroups.borland.com> <4836d44c@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> <48344401@newsgroups.borland.com> <483457ca@newsgroups.borland.com> <48360564$1@newsgroups.borland.com> <4836d206@newsgroups.borland.com> <4836d44c@newsgroups.borland.com>
In-Reply-To: <4836d44c@newsgroups.borland.com>
Subject: Re: debug stored procedures
Date: Fri, 23 May 2008 12:22:42 -0400
Lines: 15
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: <4836ef59$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211559769 24.137.214.213 (23 May 2008 09:22:49 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message