Does "debug trace" as the first line in the SP work when you turn debug on? Maybe "set echo on"?
I have not tried it. I seem to remember someone showing a way to trace a SP at an old developers conference. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis McGrath Sent: Tuesday, July 27, 2004 8:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Tracing Stored Procedures Looks like I am going to have to embed PAUSE USING commands in the code to test what is happening in my form. Drat!!! Thanks for the info. Dennis --- Bill Downall <[EMAIL PROTECTED]> wrote: > Dennis: > > >From the HELP files: > > To Trace a Stored Procedure > > Enter the following code at the R>prompt: > > TRACE SELECT sys_proc_src FROM sys_procedures WHERE + > sys_proc_name = 'procname' > > Unfortunately, if your SP uses parameters, I know of no way to TRACE > an SP and > also pass parameters to it. I have submitted that as a feature > request. > > Bill > > > On 27 Jul 2004 at 6:49, Dennis McGrath wrote: > > > Is there any way to trace a stored procedure to be used with CALL? > > > > I've searched RSytax.com in vain. > > > > Using 6.5++ > > > -- Bill Downall > [EMAIL PROTECTED] > 317.297.3810 > > ******************************** > Notice: The ISP for our domain, SBC Ameritech, > is currently having a problem keeping up with the > volume of email and spam going through their mail > servers. This means that sometimes mail gets through > to and from us immediately, and sometimes the SBC > Ameritech web hosting mail servers get constipated, so that > delivery of mail to or from downallconsulting.com > can be delayed by as much as half a day. If your message > is urgent, please follow up with a telephone call. > ***************************************** > >
