[navyashree.r]

Hi,

Quote:

It would be comfortable to have the existing text selected, when you click into the text boxes for “First Row:” and “No. of Rows” on the “Table Data” tab. You could then easily overwrite the old value without having to delete the old text first.

Additionally, please allow “enter” inside these boxes to refresh the view.

Highlighting the Text in the Text boxes when focus is made and also “Refresh” when the focus is inside the text boxes. Regarding this we will discuss.

larsen wrote on May 12 2009, 04:53 PM:

Sorry, I don´t understand the problem. There already is a “refresh” button next to the text fields. What difference would there be whether I pressed “enter” or clicked on “refresh”? I just want to use the keyboard.

Here, if the focus is in “No. of rows” text box press TAB. The 'Refresh' button gets selected. Now, press 'Enter' the table data will be refreshed.

And also if the focus is in the Grid (1st row, 1st column) position press SHIFT + TAB the Refresh button will be selected. Next, press 'Enter' through keyboard, the table data will be refreshed.

Regards,

Navya

[navyashree.r]

Hi,

Quote:

I then realized, after trial and error, if I kill the connection to the DB (close the inner window with the X at top right), and re-connect to the server again, the data now shows with the update I made. But not until I do this, “refresh” does not work either.

I take that back about “refresh” not working.. it does. However, the previous versions used to essentially “refresh” the data if “view data” was selected again on the table.. this is how I usually would refresh. I guess that has been modified.. I will learn to use the “refresh” key.

A better simple solution is there to see the updated changes in table data after executing the query. See image “refreshissue.JPG”. Here, enable the option “Automatically refresh Data tab on focus”, once this option is checked after executing a query the table data displays with updated result when we focus on table data or just clicked on “view data” again.

Regards,

Navya

[navyashree.r]

Hi,

Issue is confirmed and added here,

http://code.google.com/p/sqlyog/issues/detail?id=1056

And fixed internally. It will be available in next release 8.1 beta1 probably today.

Regards,

Navya

[navyashree.r]

Hi,

DbForever wrote on May 12 2009, 10:57 PM:

I do a lot of memo editing in Sqlyog and I often run a query and click on the text column and try to edit the text. Of course the query is in readonly mode and now I have to close the Insert/Update Blob field window and return to the grid and select the table name from the combo box, then re-click the same text column and finally edit the text. Whew! 😮 It would be nice if the “Insert/Update Blob Field” dialog had a check box [x] that you could click to make the field editable. Is this possible?

This issue is already in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=853

Quote:

Also on the query grid, it would be nice if there was another icon beside the Insert New Row icon that said “Duplicate Current Row”. Clicking it will duplicate the current row but does not save the row, allowing the user to finish editing the row.

We will discuss regarding this. Thank You.

Regards,

Navya

[navyashree.r]

Aidan Whitehall wrote on May 11 2009, 11:56 PM:

If you change “Escaped by: \” to “Escaped by: “, you see the same result.

Is there any combination of options that will result in “C:folder1folder2…” being saved in the exported file?

Hi,

Yes, you can avoid the Search and Replace '\' to '' in the file.

So, in the export file you can have the resultset “C:folder1folder2…” . This can be achieved by disabling the option “Escaped By” in the Export table data/Result as CSV — Change option. See image “escape.JPG”.

This will retrieve data without escaping any characters and retains '' in resultset.

Regards,

Navya

[navyashree.r]

Hi,

To change the sequence of columns in a table, select the table in the Object Browser and select Reorder Columns from the popup menu or Table menu — Reorder column(s) or just press Ctrl+ALt+R.

Select any column and click Up or Down button to move the column up/down. Having re-sequenced the columns, click Re-Order to save the table with changed structure. The column data in the table gets re-arranged accordingly.

See image “reorder.JPG”

For more info read Help doc. Thank You.

Regards,

Navya

[navyashree.r]

Hi,

We have added this issue in our track list,

http://code.google.com/p/sqlyog/issues/detail?id=1053

We are checking on this issue and once fixed it will be available in next release.

Regards,

Navya

[navyashree.r]

We identified issue. It will be available in the next release 8.1 Beta 1.

[navyashree.r]

Hi,

Issue is added here,

http://code.google.com/p/sqlyog/issues/detail?id=923

Regards,

Navya

[navyashree.r]

Hi,

You can try turn off Auto-Complete from 'preferences'. Just to find out if this is the issue. Could you please confirm?

Regards,

Navya

[navyashree.r]

Hi,

Issue is confirmed. If alias is used for table, autocomplete is not working.

Added in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1052

Regards,

Navya

[navyashree.r]

sqldave wrote on May 4 2009, 04:13 AM:

So at the beginning of a line, I type a small x. It becomes capitalized and colored red. Just wondering why.

Hi,

“X” is a MySQL keyword. So, as soon as we type in editor it becomes capitalized and colored red. For example,

Type 'select' word in editor and just enter space it changes color to red and becomes capitalized “SELECT”.

We do have options for Keywords and Functions in menu Tools –> Preferences –> Editor. Here, we can change the default to UPPERCASE, lowercase or Unchanged. See image “keywords.JPG”

So, please confirm whether did u enter space after typing 'x' letter?

FYI read link below regarding Hexadecimal values,

http://dev.mysql.com/doc/refman/5.0/en/hex…mal-values.html

[navyashree.r]

sqldave wrote on May 4 2009, 04:23 AM:

Once I have an empty query window, I would like to able to right-click on the mouse (with pointer in blank window) and have “open file” as an option.

Hi,

Thank You for your valid request. Its been added to our issue track list,

http://code.google.com/p/sqlyog/issues/detail?id=1050

Regards,

Navya

[navyashree.r]

peterlaursen wrote on Apr 29 2009, 08:48 PM:

agreed .. sorting and filtering in RESULT tab was left behind long ago. This reason why it is still not there is some problems with BLOBs.

Hi,

Request is added in list. Thank You.

http://code.google.com/p/sqlyog/issues/detail?id=599

Regards,

Navya

[navyashree.r]

We will look into priority. Thank You.

[Author]

Posts