Feature request – table data

[crivera]

Great program. 🙂 I am using v4.06.

When I am trying to modify table data, I constantly have to swith between the Table Data & Result tab to determine which row to edit because I use columns/fields of variable length TEXT/BLOB data type.

In the Table Data tab, would it be possible to add some type of select list box that would display the TEXT/BLOB column if a different format? For example: text, binary, octal, hex, image, or any other format I forgot to mention. The data may need to be truncated to the column width depending on the display option selected. You would still need to click on the cell to edit it (maybe a smaller icon next to the data displayed). I understand that depending on the display option, it may take a bit longer to refresh the Table Data.

Thanks

[peterlaursen]

did you check the 4.07 beta/RC-version ? It now displays the beginning of the string/data (using the defined character set for TEXT and the default character-set for non-TEXT, I believe)

A binary/hex view of data with the BLOB-viewer I know is on the TODO-list (and can't be far away).

Making the BLOB-viewer resizable is too.

This I don't understand:

Quote:

When I am trying to modify table data, I constantly have to swith between the Table Data & Result tab to determine which row to edit

You can edit from the RESULT-tab – you just will have to select the table to edit from the drop-down-box showing “Read Only” (this is security feature and very useful with multitable queries/JOINs)

[crivera]

thanks for your reply.

Quote:

This I don't understand:

When I am trying to modify table data, I constantly have to swith between the Table Data & Result tab to determine which row to edit

You can edit from the RESULT-tab – you just will have to select the table to edit from the drop-down-box showing “Read Only” (this is security feature and very useful with multitable queries/JOINs)

To view the data behind the blob object, I had to select the “Show Result In Text” option (Ctrl-L)…

Quote:

did you check the 4.07 beta/RC-version ? It now displays the beginning of the string/data (using the defined character set for TEXT and the default character-set for non-TEXT, I believe)

A binary/hex view of data with the BLOB-viewer I know is on the TODO-list (and can't be far away).

Making the BLOB-viewer resizable is too.

I will check it out.

[Ritesh]

Quote:

To view the data behind the blob object, I had to select the “Show Result In Text” option (Ctrl-L)…

You wont need to do that with v4.07 (currently in RC release). v4.07 will show a partial text of the data in the grid itself. You just need to click on it to see/view/use/work with the complete data.

[Author]

Posts