Article View: borland.public.interbase.sql
Article #226Re: debug stored procedures
From: Wayne Niddery (TeamB)
Date: Sat, 14 Jun 2008 20:07
Date: Sat, 14 Jun 2008 20:07
27 lines
2422 bytes
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-mailReferences:
<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