[peterlaursen]

sorting and filtering is high priority.  Actually we have fully functiuonal code for the DATA tab that lets you combine a filter with sorting multiple columns.  

RESULT tab is a little more complicated due to the data structure that we use (a linked list).  But we intend to solve this too!

[peterlaursen]

what you will gain?

read the changelogs: http://webyog.com/faq/33_7_en.html

+ free upgrades for 1 year.

the first fully Unicode compliant SQLyog will ship in days. Query builder, improved sorting and filtering and much more coming soon …

[peterlaursen]

virtualisation should not matter.  We use VMware and VirtualPC ourselves regulary.

Please answer

* How do you connect?  direct, HTTP, SSH?

* Is the error always occurring at the same point? (SELECT count(*) from ) ?

* Do you have any idea which of the servers that has 'gone away'?

* How do you 'copy'?  'copy database/table' from the (context) menu? If so are you able to dump and import?

[peterlaursen]

additional:

1) history is kept in memory only.  An option to save/spoll to a file has been requested before.  It is not that we don't want to do this – just a matter of priority.

2) coloring of paranthesis'es levels:  not really possible without a lot of changes, I think.

I do not understand this question: “is there any way to resort by a given column after running a query”.  The meaning of the word 'resort' in this context?.  Filtering by the contents of a cell will be implemented very soon, if that was the question.

[peterlaursen]

See attached!

this dialogue (the 'connections manager') opens everytime you start SQLyog.

You can also select (from the menu) fille .. new connection.

Finally the first/uttermost left icon in the icon bar brings up the dialogue.

[peterlaursen]

Yesterday we had this discussion:

http://www.webyog.com/forums//index.php?sh…view=getnewpost

There is no activity at the moment to build a 'native' Max OSX version.

[peterlaursen]

Thank you for reporting.

I think Mac user always (just as was the case with OS/2 users (and I was one for about 5 years!)) want the 'real thing' and not a windows program.

You will need to go on with CrossOver/Darwine for still some time!

[peterlaursen]

sorry for the smiley .. it should have been a 'b' and not 😎

[peterlaursen]

a 3 has not come from nowhere. It came from the later (most rightly) of the two colums showing the same value.

A simpler example

CREATE TABLE `aaa` (

`a` int(10) default NULL,

`b` varchar(20) default NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

and now insert a few rows (1,a),(2,:cool:,(c,3)

and “select aaa.a, aaa.* from aaa;”

set the FIRST aaa.a column in the grid to NULL won't help. You will have to either use a query where the same row is only displayed once or edit the LAST of the aaa.a columns.

Did I understand everything correct?

[peterlaursen]

Ok now I understand!

When updating SQLyog updates every column in the grid. There is no logic in the grid to 'remember'

that a row is printed there twice.

With this query

SELECT a.id, a.name, a.* …

it happens as you describe it. Why do you need to “SELECT a.id, a.name” explicitly when you “SELECT a.*” ??

Do you know any graphical grid-type database client doing otherwise?

[peterlaursen]

I think it is a limitation in the database actually. But probably MA drops and recreates the FK 'transparently'.

We will research this.

[peterlaursen]

You need RELOAD privileges for 'flush' operations.

Hust uncheck the 'flush' options.

Did that help.

BTW: you should upgrade SQLyog

[peterlaursen]

1)  Would be very complicated to implement in the tokenizer.  But the idea is snice

2) What is the difference to the SQLyog HISTORY tab?

3) Alias'es and autocomplete is being considered.  Also a nice feature, but we are uncertain exactly hjow to do this

4) In my YOG table/column names are black, functions are lilac/purple.  This is the standard setting.  Screenshot?

5) You can copy a single cell into clipboard (Ctrl-C).  You can also 'display results in text' and you can copy whatever you like

[peterlaursen]

I am afraid I do not understand your question.

If this:

http://www.webyog.com/faq/27_114_en.html

.. does not answer the question then please try to ake another way!

[peterlaursen]

we have tried to reproduce on 2k (with all SQLyog versions).  We cannot reproduce.

We need sample data from you to do progress.

[Author]

Posts