[mhsa]

I noticed the same thing. I think SQLyog strips off the carriage returns, thus MySQL thinks that the statement is all one big long line (instead of the several lines you typed in). Looking at the history pane gives you some idea… When you use an inline comment, MySQL ignores everything after it until the carriage return.

You can only use the C-style comments, /* … */. These will work for in-line comments, and allow you comment out sections in the middle of your statements.

HTH!

[mhsa]

Using 3.51 (trial), Win2k, en_US

I can confirm the bug. The problem exists for both 'Find' and 'Find and Replace'. The dialog gives focus back to the parent window as soon it receives it. This ensures that you cannot type anything into the dialog, or use the buttons. The only way to close the dialog is to use the window's close box.

[mhsa]

Just upgraded to 3.51 (trial), Win2k, en_US.

Syntax highlighting problems persist. It seems that comments are causing the largest share of the problems.

I have attached a screenshot to illustrate the problems. The only difference between the first (correctly highlighted) screen and the second (incorrectly highlighted) screen is one line of scrolling. When the comment terminator scrolls off-screen, the syntax highlights incorrecrtly. When that line scrolls back into the visible pane, it correctly highlights the syntax.

See attached.

[mhsa]

Just installed 3.51 (trial), and unfortunately, my scrolling problems persist.

The window will scroll down by a line, but just as quickly jumps back up to the line it just came from.

Also, the width and position of the verticle scroll bar changes drastically when ever the window scrolls past a new SQL statement in a script of many statements.

In fact, I've observed a new scroll problems in 3.51 than I had not seen in in 3.5. I am not able to consistently reproduce it, but there are times when I drag the verticle scroll bar down and the window displays both the scrolling contents, and the top of the file, so fast in alternation that they appear to be superimposed over each other (like > 20 frames per second). Unforeturnately, I can't seem to reproduce the problem.

[mhsa]

Thanks! We're looking forward to adopting SQLyog at our organization.

[mhsa]

Cal or Shadow,

What platform are you using?

I seem to be having many problems with the query text pane. Is SQLyog dependent on any non-statically linked libraries? It almost seems like I have a different version of MSVCRT.DLL, .NET Assemblies, or some other such thing.

Thanks for the help!

[mhsa]

Syntax highlighting does not recognized CONVERT or CAST functions in MySQL.

[mhsa]

Also, repaint fails to occur (i.e. no syntax highlighting) when CTRL+TABing between two open query windows. The pane only repaints when there is an event that triggers it, e.g. scrolling, pressing an alpha-numberic or symbol key, etc. Arrow keys, home/end do not trigger repainting. Page Up/Down does, however.

[mhsa]

I have a Logitech Trackman Wheel. However, I found a similar behavior on my HP Pavilion laptop under Windows XP HE and its trackpad. The trackpad seems to work a little better, however. I wonder if the trackpad continues to send scroll messages even when your finger is relatively motionless, and if the trackman sends many fewer messages.

I wonder if the differences I'm experiencing are in anyway related to international differences in Windows, etc.? If it makes any difference, my OS, etc., is configured for en_US.

Despite the few issues I've come across so far, SQLyog is a great product. Good work!

[mhsa]

That's a shame 😉

As a data analyst, I have tons of canned queries. Such a feature would have saved several steps.

Perhaps you might consider renaming the option 'Restore Database' rather than 'Execute Batch File'. Since SQLyog adheres to the 'log everything' principle, this further confused me; I expected the batched statements to be logged, etc.

Oh, well. Thanks anyway!

[mhsa]

This happens using 3.5. (trial).

[Author]

Posts