Query Result Inline Editing: Get Rid Of The Table Combo Box

[PhaseTwenty]

I got this email in response to uninstall feedback on my trial copy of SQLyog:

Quote:

You had written

Quote:

User Interface:

The feature that sealed the deal for me is the ability to edit query results inline (i.e., clicking the cell I wish to change, and making my change). However, the feature has one annoyance for me: if the query whose result I'm editing was a join, I have to select the source table that I'll be editing, at which point the columns from that table in the result become editable. I know what I want to edit, do I care which table it was from? No. It can make my edits very cumbersome as the number of tables goes up.

If you have more than one table in the resultset, Result tab will contain a combo-box that allows you to choose table to edit. This table columns are highlighted and all other columns are grayed as the other columns doesn't belong to the selected table.

Kindly drop a mail at our support ticket system: [email protected] or get back to us on our forums: http://www.webyog.com/forums so that we can assist you. Thank you for using SQLyog.

So, here I am. My office ended up with 2 licenses for SQLyog Enterprise (good on you, Black Friday).

The response suggests that the reader didn't understand my point: I don't want to mess with the combo-box because it's not necessary. Was I not clear?

[peterlaursen]

1) If you have a single table referenced in the query we have 'execute for update' (F8 or the arrow icon with a small table) and you will not need to 'mess' with the combo.

2) With queries referencing two tables (in a JOIN) we cannot omit the combo. The result set may contain identically named columns. The program cannot know what table user wants to update in that case. User will have to tell the program.

[Author]

Posts