"Show Results In Text" broke with 4.0x

[ronald]

In 4.0 beta 5 and previous, when you choose the “Show Results In Text” option and right-click on a table and choose “View Data”, sqlyog would correctly show the results in text. Now with 4.07, the doing this shows the results in the grid instead. One of my favorite things about sqlyog is being able to copy-n-paste an entire table's text, or even just a few rows. Please put it back to the old way!

[peterlaursen]

from menu: edit .. show results in text .. works here.

You did not simply overlook that option ??

But the option is not saved to .ini-file when closing SQLyog.

The grid view is implemented to make it possible to delete or update data from RESULT.

The new DATA and RESULT-pane as of 4.0 is a major improvement in my opinion!

[ronald]

peterlaursen wrote on Jul 8 2005, 03:09 PM:

from menu: edit .. show results in text .. works here.

You did not simply overlook that option ??

But the option is not saved to .ini-file when closing SQLyog.

The grid view is implemented to make it possible to delete or update data from RESULT.

The new DATA and RESULT-pane as of 4.0 is a major improvement in my opinion!

So, it works if you do “edit .. show results in text”, and then right-click a table and choose “View Data”? Not for me, this is a bug. You will notice, now right-clicking and choosing “Insert/Update Data For The Table” and choosing “View Data” does the EXACT SAME THING, even with the text option specified. in previous versios, you'd only get the grid with “Insert/Update Data For The Table”

[peterlaursen]

Quote:

Not for me, this is a bug.

Show results in text only has effect on result-tab not data-tab!

I disagree with you! Nothing should be changed back here! It's a major improvement!

Data-tab always show ALL data in table, result-tab the result of last SELECT-query.

You could do a “select * from …” , choose “show result in text” and it works from result-tab.

But I would not mind an option like “show table data in text” – though I would probably never use it myself.

[ronald]

peterlaursen wrote on Jul 8 2005, 04:01 PM:

Quote:

Not for me, this is a bug.

Show results in text only has effect on result-tab not data-tab!

I disagre with you! Nothing should be changed back here! it's a major improvement!

Data-tab always show ALL data in table, result-tab the result of laset SELECT-query.

You could do a “select * from …” , choose “show result in text” and it works from resultpane as you want.

But I would not mind an option like “show table data in text” – though I would probably never use it myself.

Wrong, data tab will only show all data up to the row limit specified in SQLyog's preferences. How is it an improvement to have “Insert/Update Data For The Table” and “View Data” do the EXACT SAME THING? Why not just delete the “View Data” option entirely if it doesnt serve any different purpose than “Insert/Update Data For The Table”? A user like you who wants the grid, and wants to be able to delete or update the data, should choose “Insert/Update Data For The Table”. In previous versions, if you chose “View Data”, and had text mode enabled, the table rows would be displayed as text. Now something is broken, and choosing “View Data” while in text mode has the exact same effect as choosing “Insert/Update Data For The Table”.

I dont know about you, but over the span of a week id have to be typing “select *” thousands of times! On another slower machine I have 4.0 BETA 5, which behaved correctly, I wish I had the install file for that version.

[Ritesh]

I will look into it tomorrow. Maybe we will implement it in v4.1.

[peterlaursen]

Yes this is correct

Quote:

ill only show all data up to the row limit specified in SQLyog's preferences

This is also correct

Quote:

In previous versions, if you chose “View Data”, and had text mode enabled, the table rows would be displayed as text.

But with a SELECT-statement I can choose only SOME columns and SOME rows to be shown i RESULT-pane.

I don't have the imagination that anyone would need to show a complete table (all rows & all colums) in text. But since you do, you can request a “show table data in text” option.

The major improvement with 4.x is that you can edit data from result-view!

[ronald]

Ritesh wrote on Jul 8 2005, 04:29 PM:

I will look into it tomorrow. Maybe we will implement it in v4.1.

[post=”6365″]<{POST_SNAPBACK}>[/post]

sad to see its not fixed in 5.0 🙁 All that would need to be done is for the table data to show up in text when the “Show Results In Text” option is specified.

[Author]

Posts