Devart Forums

Hi,

I would like to request a feature that allows you to run a script statement-by-statement.

This could be done, i guess, by creating a "run mode" or something like that (RunAll or RunPerStatement) and events that tell you which statement (and line this statement is on) is the current and allow you to continue/stop.

Obviously, if the MySQL components could have such a change as well, the better


--
Martijn Tonies
Upscene Productions

You can implement such functionality by using BeforeExecute event handler and Omit parameter in it. In the nearest future we will release new versions of ODAC and MyDAC with the script component that has more functionality.

challenger wrote:You can implement such functionality by using BeforeExecute event handler and Omit parameter in it. In the nearest future we will release new versions of ODAC and MyDAC with the script component that has more functionality.

I fail to see how you can implement such a thing by using that event.

I don't want to omit anything, I want to execute a statement, get some kind of feedback as on which line the script is now, then stop execution.

--
Martijn Tonies
Upscene Productions

TOraScript has StartPos, EndPos, StartLine, EndLine properties that show information for current statement. So you can use these properies in OnBeforeExecute event handler. You can stop execution by setting Omit to True for all statements starting from current one. Another way is calling ExecuteNext method while some flag is True instead of calling Execute method.

challenger wrote:You can stop execution by setting Omit to True for all statements starting from current one.

That's an interesting way of implementing it

I'll see what I can do, I'm, however, very interested in the more advanced script component and feedback for it.

--
Martijn Tonies
Upscene Productions

I think a lot more of people are interested