Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 15 of 15 total |
Totally out of my depth with stored procedures. |
Thu, Jul 30 2009 5:40 PM | Permanent Link |
Leslie | Tim,
Steve, << There's a built-in script debugger in the EDB Manager that you can use to set breakpoints, examine local variables, etc. It's very helpful with complicated scripts/procedures/functions/jobs/triggers.>> I have wanted to ask this so many times, but I never did: would it require lot of work to build an SQL script debugger integrated to the engine from what you already have? Leslie |
Thu, Jul 30 2009 5:55 PM | Permanent Link |
Steve Gill | "Tim Young [Elevate Software]" wrote:
> Do you mean in a script ? EDB scripts are a little more difficult to handle > like this because they rely on executing from the begin to the end, and > aren't just a series of SQL statements. Sorry, yes I meant a script. It's something I do often in the MS SQL Studio app. In a stored procedure you can select a block of SQL and hit execute, and it executes just the selected code. I thought it would be handy to be able to do that with EDB Manager. It's no big deal as I can work around it - just a suggestion. Steve |
Fri, Jul 31 2009 12:30 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Leslie,
<< I have wanted to ask this so many times, but I never did: would it require lot of work to build an SQL script debugger integrated to the engine from what you already have? >> You can see how it is implemented by looking at the EDB Manager source code. It is already part of the engine, which is how we allow you to remotely debug scripts using the EDB Server. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jul 31 2009 12:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Steve,
<< Sorry, yes I meant a script. It's something I do often in the MS SQL Studio app. In a stored procedure you can select a block of SQL and hit execute, and it executes just the selected code. I thought it would be handy to be able to do that with EDB Manager. It's no big deal as I can work around it - just a suggestion. >> No problem. I just see potential issues with uninitialized variables, etc. if we don't execute prior statements that may be required by the selected statements. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jul 31 2009 6:19 PM | Permanent Link |
Steve Gill | Hi Tim,
> No problem. I just see potential issues with uninitialized variables, etc. > if we don't execute prior statements that may be required by the selected > statements. Yes you have to remember to select all of the valid code, or copy and paste sections and then select before running. If there's anything missing it comes up with an error message. It is possible to get yourself into trouble though (he says, having done just that). Steve |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |