distal-attribute
distal-attribute
distal-attribute
distal-attribute

Feature Wish

User, date Message
Written by keithg
2 years ago
Category: Feature discussion
3 posts since Sat, 27 Oct 12
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.
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
Can you show some screeny of this dialog in Toad, please?
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
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.
Written by keithg
2 years ago
3 posts since Sat, 27 Oct 12
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]
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
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?
Written by keithg
2 years ago
3 posts since Sat, 27 Oct 12
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
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
The Toad dialog asks for variables, not for parameters, please look at your screenshot.
 

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