Hello,
Would it be of interest to create a pop-up box to capture all parameters for input to a procedure instead of a one-by-one input, and further, possible to give these parameters a 'friendly' name instead of the abc_123_xx usually needed to create a procedure? I think this would make the input a bit friendlier and users can see more of their input requirements before committing to a procedure. Have seen similar on Toad.
Feature Wish
Thanks for the screenshot via pm. It's cut in the lower area I guess due to some connection problem on your side, but I can see the upper area of the dialog you mean. It's called "Bind variables", and I guss it is meant to fill inline variables, not parameters to that procedure. In your case, you have one similar named variable to each parameter, so this might look like a parameter dialog, but it shows the "@" character for each variable, did you notice that? I'm confused about what Toad does with such a dialog.
Hello Anse,
Thanks for your patience.
Essentially, the dialog box has the same function as in Heidi, but in this case a user can enter all variable information in one box before committing to the procedure instead of filling info and then hitting 'OK' and fill the next etc.. I think this gives the user some ability to see and check what information is needed for the next variable before they fill out the dialog. I just think that this may be a bit more helpful for users, in my environment anyway. If I am asking for multiple variables in a proc, it can get lead to mistakes if they can't see/remember what they just entered because heidi doesn't reflect what was entered until it is too late. It's simply a visual thing.
Best Regards,
Keith[i][/i]
Thanks for your patience.
Essentially, the dialog box has the same function as in Heidi, but in this case a user can enter all variable information in one box before committing to the procedure instead of filling info and then hitting 'OK' and fill the next etc.. I think this gives the user some ability to see and check what information is needed for the next variable before they fill out the dialog. I just think that this may be a bit more helpful for users, in my environment anyway. If I am asking for multiple variables in a proc, it can get lead to mistakes if they can't see/remember what they just entered because heidi doesn't reflect what was entered until it is too late. It's simply a visual thing.
Best Regards,
Keith[i][/i]
Yes, true. Let me appologize for using 'variable' where it should have been 'parameter'. The Toad pop-up takes parameters as does Heidi.
Still, I think it would be a feature to think about, but a little more trimmed down. I agree with your stance on not making Heidisql into a over-featured prog, I just want speed, simplicity and reliability.
Thanks again,
Keith
Still, I think it would be a feature to think about, but a little more trimmed down. I agree with your stance on not making Heidisql into a over-featured prog, I just want speed, simplicity and reliability.
Thanks again,
Keith
Please login to leave a reply, or register at first.