Split type and length in table editor
I suggest you split the data type and length elements in the table designer (new table) so that users can tab through entering column information. The current layout requires using the mouse to, for example, specify a different varchar length
-
Dazz Knowles commented
My request was for type and length to be split - this has not been done. Having ('Name', 'Data type', 'Unsigned', etc) is inefficient. Having ('Name', 'Data type', 'LENGTH', Unsigned, etc) would allow users to create a table with minimal key strokes and will no mouse interaction.
The only way to achieve this currently is to type the data type name in fully so VARCHAR(25) for example which is 11 keystrokes as opposed to VARC<tab>25 which would only be 7 - doesn't sound like much but it saves time, especially as less keystrokes means less chance of typos. Obviously pressing tab would select the best matched datatype, like it does now. Ideally the tab functionality would be disabled if no valid datatype matched the user's input so far.
You have added a load of per-column properties to the right hand side of the table definition but these are of no real use as you can't tab through the properties or add new columns via this interface.
> Further to the above if on the parameters page you type a datatype into the Type field without first selecting a type, when you tab out of it it replaces your typed value with the default (VARCHAR).
This has been fixed at some point (I created this suggestion and that comment over 3 years ago).
-
AdminDevart (_, Devart) commented
> I have version 7.2.53 installed and I can't see where this has been implemented? It still seems impossible to specify/edit columns types and lengths separately without using the mouse.
> There's a new view on the right of the table definition with each property for a column neatly laid out but you can't tab through these and you can't use it for new columns.We were not able to reproduce this issue. We are able to navigate through the
fields of a column ('Name', 'Data type', 'Unsigned', etc) with the 'Tab' key.
Please check that you have successfully upgraded to the latest build 7.2.53.> Further to the above if on the parameters page you type a datatype into the Type field without first selecting a type, when you tab out of it it replaces your typed value with the default (VARCHAR).
You could return with the UP/DOWN/LEFT/RIGHT keys and modify the default VARCHAR type.
-
Dazz Knowles commented
I have version 7.2.53 installed and I can't see where this has been implemented? It still seems impossible to specify/edit columns types and lengths separately without using the mouse.
There's a new view on the right of the table definition with each property for a column neatly laid out but you can't tab through these and you can't use it for new columns.
-
Dazz Knowles commented
Further to the above if on the parameters page you type a datatype into the Type field without first selecting a type, when you tab out of it it replaces your typed value with the default (VARCHAR).