Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Drop down list - LIMIT 1000

erici's profile image erici posted 11 years ago in General Permalink
Hello,

It is nice feauture that "Heidi displays the first available text column in the foreign table. So, the user doesn't have to guess what id XYZ was" as anse Posted: Thu, 15 Apr 10 00:55

However, my foreign table has more then 1000 rows and therefore I am not able to pick all the IDs XYZ I want. Is there a way to tell Heidi
either to show me all rows in the foreign table (and tools > preferences > data does not change anything in this case)
or to disable this feature?

Thank you in advance.

ansgar's profile image ansgar posted 11 years ago Permalink
That should not be such a problem as the combo box allows entering custom data. Even if these 1000 were configurable you would not want to increase that to some value of 1 million which would probably be required for another table.

See also issue #1849 for discussion and comments.
erici's profile image erici posted 11 years ago Permalink
It is a problem as the box allows me only to enter data available in the drop-down list (the first 1000, in my case, Surname)

SELECT `ID`, LEFT(`Surname`, 256) FROM `Persons` GROUP BY `ID` ORDER BY `Surname` LIMIT 1000;
ansgar's profile image ansgar posted 11 years ago Permalink
Oh yes, you're right, that combobox only allows selecting, not typing, so it's able to distinguish between displayed and inserted value. Sigh.. guess we really need an option to decrease, increase that max value, plus a "0" value to disable this feature.
erici's profile image erici posted 11 years ago Permalink
Yes, that's what we will need in this case.
Can this be implemented? I mean, in due time? Or should I ask our "webmaster" to downgrade Heidi (as in Heidi 4 this feature was not implemented).

Thank you for your effort so far.
ansgar's profile image ansgar posted 11 years ago Permalink
Perhaps, don't know, but not in the next two days. You can always downgrade to 5.0 - very simple.
erici's profile image erici posted 11 years ago Permalink
Hello,
I would like to know if something is going on with regard to the that problem with the combobox?
As I am using HeidiSQL on an university server they do not want to downgrade it.
ansgar's profile image ansgar posted 11 years ago Permalink
Nothing going on currently. Thinking that I should just disable that feature if the foreign table has more than 1000 rows, and display the normal text input in that case.
erici's profile image erici posted 11 years ago Permalink
For me that would be fine!
Thank's in advance.
Code modification/commit from ansgar.becker, 11 years ago, revision 3390
Do not create drop down menu on foreign key'd cells in data grid if the foreign table contains more rows than we display in the drop down. That way, the user is able to enter other foreign values than those provided by the dropdown list. See http://www.heidisql.com/forum.php?t=5736#p5930
ansgar's profile image ansgar posted 11 years ago Permalink
r3390 is it - the drop down list is only created if rows are less than 1,000.
erici's profile image erici posted 11 years ago Permalink
Thank you!

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.