[Nick_Ring]

I think it is a Window thing, as I have seen it a lot. The problem can usually (but not always) be traced down to either DrawText or DrawTextEx API calls, with the calling routine not passing in 'DT_NOPREFIX' in formatting options of these two API calls.

[Nick_Ring]

The only problem with the History tab is that is only relevant for the current session. Close that session or restart SQLyog and the history is cleared. Something more permanent and that can handle multiple sessions of SQLyog (not uncommon for me to have two or more open, working on different things) running at once.

The 'global' history (which I will call it for now), should also place multiple queries (when selecting 'run all queries' or 'run selected query') in the global history as one entry so the whole sequence of commands are retrieved a once, which is slightly different to the (“session”) history does now – “session” history stores each one seperately so going back, it can be hard to figure would what was ran together and what wasn't.

Reading the History tab requests, the last one is similar to what am I proposing. I wouldn't say I have a precise implmentation but something similar to MySQL Query Browser's implementation (has been a while since I have played around with it).

[Nick_Ring]

The query is quite irrelevant – It just happened to be the query I was playing around with then found the (windows) bug. 😀

select 1 as '&';

will show an '_' as the column name, while

select 1 as '&&';

will show '&' as the column name.

select 1 as '&&&';

will show '&_' as the column name.

The problem is how Windows handle the '&' character (happens a bit in programming). Either the grid component needs to tell Windows do not use '&' as a hot key character (like in menus) or the application writer needs to do search and replace – search for '&' and replace with '&&'.

[Author]

Posts