Form event calling stored procedure (OpenInsight Specific)
At 11 MAR 1998 05:09:51AM Jacob Ignatius wrote:
I have come across forms in the system I am working on where there is an event (in most cases pushbutton click) that calls a stored procedure.
In the stored procedure are routines that do various things depending on the parametrs passed to it.
The obvious advantage I can see is that all code associated with the form is stored in a separate stored procedure. I can see this being very useful during development when all the code for a form can be seen at once. Are there any other advantages?
At 11 MAR 1998 08:17AM Cameron Revelation wrote:
Jacob,
I have come across forms in the system I am working on where there is an event (in most cases pushbutton click) that calls a stored procedure. In the stored procedure are routines that do various things depending on the parametrs passed to it. The obvious advantage I can see is that all code associated with the form is stored in a separate stored procedure. I can see this being very useful during development when all the code for a form can be seen at once. Are there any other advantages?
Two main advantages that developers have related to me:
1. Without closing the form, you can modify the code and recompile it and then the form will start using the new code.
2. To switch between graphical layout and scripting, you simply alt-tab from the Form Designer to the System Editor, as opposed to shift-double-clicking on a control to get to the script editor and then selecting the event from the dropdown and then pressing ctrl-s to close the script editor.
Cameron Purdy
info@revelation.com
At 12 MAR 1998 11:45AM Aaron Kaplan wrote:
Take it for what it's worth, but I don't use event scripting unless I absolutely have to. Everything is quickevents calling comuter module procedure. It's the same idea as all the omniscript stuff, but implemented smoother.
apk@sprezzatura.com
