Drop down list - LIMIT 1000

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.

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.

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;

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.

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.

Perhaps, don't know, but not in the next two days. You can always downgrade to 5.0 - very simple.

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.

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.

For me that would be fine!
Thank's in advance.

r3390 is it - the drop down list is only created if rows are less than 1,000.

Thank you!