[TGKnIght]

Well I was thinking this had stopped happening.. was working fine for the whole time since I upgraded up until just now.

I got the same problem.. I was altering a table.. I alt-tabbed to another window to look up something, and SQLyog closed spontaneously without warning. I had the application opened for at least 4 hours..

I'm on SQLyog 5.2 Beta 4, Windows XP SP2.

[TGKnIght]

Yes that's me, and I have beta 4 installed so I'll let you know if this still occurs.

[TGKnIght]

Ok finally got the 5.2 beta 4 installed and looks like this problem is solved for me.

Send me CC info and you can see it too! 🙂

[TGKnIght]

Sorry I am trying to help by reporting bugs I find.. no need to be condescending….

I have also submitted a support ticket regarding why the download page doesn't recognize my registration anymore… THANKS!

[TGKnIght]

Ah oops… I had seen the option but did not know what it was for.. Will test it out in a little while.

Thanks!

[TGKnIght]

Yes the sticky idea seems like a great implementation..

I think if you do something like that, the stickied results should open up a new pane in addition to the result pane belonging to the particular tab you are on.

Imagine that we have a “tab pane” and a optional “sticky pane”.

You run a query, the results fill in the “tab pane” which is the only visible pane at this point..

Next you click the sticky button, which opens up the “sticky pane” and fills the results with the same info in the current “tab pane”.

Now you click to a different query tab, the “sticky pane” stays the same, but the “tab pane” is now a fresh start.

The panes should be drag and droppable too so the user can choose side-by-side or over-under layouts.

[TGKnIght]

peterlaursen wrote on Jun 7 2006, 12:35 PM:

I do not think the Editor component of SQLyog has the 'logic' or 'parsing ability' to do something like that.

Basically it does only KEYWORD highlighting and tokenizes for DELIMITERS (the standard ” ; ” and any user defined created with the DELIMITER keyword) – no parsing is done (this is done by the parser component of the MySQL server itself – as it usually is the case with Database Client software).

To do this I think we will need to add a complete new component – a 'pre-parser' of some kind.

What editor do you use that has this feature?

Personally I use notepad++ as my all in one editor, but I would like to use SQLyog as my all in one mysql editor… notepad++ is open source and written in c++ perhaps you guys can find out what he is using for this purpose.

I don't know what you mean by 'pre-parser' as this feature would be something that occurs while you are typing or when you move your mouse over…

And even if does not have the ability to highlight with a mouse over or cursor over, then even something like color coded pairs would help.

[TGKnIght]

For example

SELECT *

FROM (

select * from table

) data1

When your cursor is on the first parentheses, it highlights the second one so you easily identify where parentheses end and begin.

Of course for this simple example it doesn't seem neccessary, but I have some very complex queries where there are many many parentheses and sometimes they aren't indented correctly so it is hard to follow without the syntax highlighting… I have to copy the SQL into a different editor to get that feature.

[TGKnIght]

I have noticed from a couple forums I frequent that people have developed some type of forum spamming software..

[TGKnIght]

Ok good now we on the same page 🙂

So you are saying the line breaks are stripped only on display..

As I mentioned when I view my job xml file, the line breaks are still present, although they are not when displayed via the notification query window.

[TGKnIght]

I either write the query entries directly in the 'Notifications Services' query window or copy it out of SQLyog's normal query window…

The first time when I type it in, or copy it in, it shows the line breaks, however if I go back to edit the query, the line breaks are not displayed when it pulls from the job xml file.

When I view the XML file with my own text editor the line breaks display there correctly.

I have not used my text editor to modify the job files directly, only to view.

[TGKnIght]

I'm sorry, I should have specified which query window 🙂

Specifically for jobs, when you enter a query to execute, it does not save the line breaks.. i.e. in the XML file there is an invisible /n for a line break… The query window should parse this 🙂

I have attached a screenshot of the query window I speak of..

[TGKnIght]

Ah ok that must have been it… So the SJA can run under linux and be scheduled using cron?

I assume then as a registered user of the windows client, we have access to both versions of the SJA?

[TGKnIght]

Hmm thanks for the reply…

I would really like the “BOTH” option 🙂

Perhaps an easy way would be to add delimiter parsing into the custom subject..

IE

Customer Data Import Success – {yyyy-mm-dd hh:mm:ss}

[TGKnIght]

Oh i see… I must have misread somewhere.. Could have sworn there was a Linux version as well… Thanks for the clarification 🙂

[Author]

Posts