🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #226

Re: debug stored procedures

#226
From: Wayne Niddery (TeamB)
Date: Sat, 14 Jun 2008 20:07
27 lines
2422 bytes
"Isaac" <no@no.com> wrote in message 
news:4853fd43$1@newsgroups.borland.com...
> I have IBExpert and like other tools I can debug stored procedure from the 
> database itself but I wonder if there is a tool or something that can let 
> me step through stored procedure from inside Delphi as the application in 
> debug mode ?
>
> because I could miss easily an action done by Delphi to the database so 
> when I debug my stored procedure I see every thing is all right but result 
> was different I test the application from Delphi - I hope I was clear


The stored procedure debugger will let you see the parameters that were 
passed, so if you supply the same ones you know your Delphi program  would 
be sending (which you can see in the Delphi debugger) then you *must* get 
the same  results.

However, it is important to understand that InterBase does not provide any 
actual debugging interface and the debugger you are using is in fact 
*emulating* the execution of the stored procedure and stepping through its 
emulation, not the *actual* InterBase execution. While in most cases it is 
going to be accurate (the developers of it try very hard), there can 
occasionally be differences.

-- 
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca) 
Technical Details
Message-ID: <48542502$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.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: <4853fd43$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,c1bdf611911e6915
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: <4853fd43$1@newsgroups.borland.com>
In-Reply-To: <4853fd43$1@newsgroups.borland.com>
Subject: Re: debug stored procedures 
Date: Sat, 14 Jun 2008 16:07:21 -0400
Lines: 28
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: <48542502$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1213474050 24.137.214.213 (14 Jun 2008 13:07:30 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.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