Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#35 Breakpoint / Pause command

Future
open
nobody
SQL (16)
3
2005-03-09
2005-03-09
Drzewiecki T.
No

>> Daniel
I usually deal with quite long, massive SQL scripts.
I was just wondering if there is a way to set a breakpoint
in the script (so that it goes no further than a certain
line).

What I have been doing so far in order to stop a script at
a certain breakpoint is to type...
COMMIT;
DISCONNECT;
...just before the line in question.

This of course prevents the script from being executed
any further but is a bit of a hassle, since I have to re-
connect everytime.

Furthermore I can do that only once in the script...
Because if I click on "Execute" again, SQL Tools will
run it from the beginning and not from the line just after
DISCONNECT. :-/

Does this "breakpoint" or "pause" feature exist ?
Has anyone found a better way to tackle this problem ?

Discussion