Article View: borland.public.interbase.sql
Article #334Re: debug stored procedures
From: Bill Todd [TeamB]
Date: Tue, 20 May 2008 19:39
Date: Tue, 20 May 2008 19:39
18 lines
2035 bytes
2035 bytes
Isaac wrote: > > not working cant compile because of wrong number of parenthesis I > tried also to use this SUM(COALESCE(QTY,0)) but also I did not able > to compile When you say "compile" I assume you are changing the SELECT in your stored procedure. That is not what I asked you to do. The way to troubleshoot a SELECT is to run it in isql, not in a stored procedure. To solve your problem you need to find out 1) if it is the SELECT that is causing the error or something else in the stored proc and 2) if it is the SELECT you need to determine exactly what in the SELECT is causing the error. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<483328da$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!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>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: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: debug stored procedures
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>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 76.208.40.243
Message-ID: <483328da$1@newsgroups.borland.com>
Date: 20 May 2008 12:39:06 -0700
X-Trace: newsgroups.borland.com 1211312346 76.208.40.243 (20 May 2008 12:39:06 -0700)
Lines: 18
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail