Re: debug stored procedures

Article View: borland.public.interbase.sql

Article #337

Back to borland.public.interbase.sql Previous Next

#337

From: Isaac
Date: Tue, 20 May 2008 20:07

18 lines
2236 bytes

> 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.
> 

I use IBExpert so I can debug and modify my proc quickly

please see those pictures I used the two possible syntax of COALESCE and 
in both I get the same error I also tried
1-http://img525.imageshack.us/my.php?image=29721025fp5.gif
2-http://img501.imageshack.us/my.php?image=39724324nm5.gif

I tried the SQL also in other tools I get the same error

Technical Details

Message-ID: <48332f73@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!193.201.147.68.MISMATCH!feeder.news-service.com!newsfeed.freenet.de!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>

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: Tue, 20 May 2008 23:07:14 +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>
In-Reply-To: <483328da$1@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: <48332f73@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211314035 41.234.198.61 (20 May 2008 13:07:15 -0700)
Lines: 18
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!193.201.147.68.MISMATCH!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message