Feature Wish

[expired user #6653]'s profile image [expired user #6653] posted 11 years ago in Feature discussion Permalink
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.
ansgar's profile image ansgar posted 11 years ago Permalink
Can you show some screeny of this dialog in Toad, please?
ansgar's profile image ansgar posted 11 years ago Permalink
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.
[expired user #6653]'s profile image [expired user #6653] posted 11 years ago Permalink
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]
ansgar's profile image ansgar posted 11 years ago Permalink
There is no dialog in HeidiSQL where you can enter variable values, only parameter values. This is an important difference, and I guess Toad does not ask for parameters if you remove the @ variables from your procedure code, does it?
[expired user #6653]'s profile image [expired user #6653] posted 11 years ago Permalink
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
ansgar's profile image ansgar posted 11 years ago Permalink
The Toad dialog asks for variables, not for parameters, please look at your screenshot.

Please login to leave a reply, or register at first.