[FireStorm9]

I'll chime in on this one.

How about both? Would it be too difficult to add both times?

Something like:

Q: 5ms D: 15ms

Or the simpler way that Peter mentioned earlier:

5ms/15ms

That would be great, as I also strive to get every last millisecond out of the queries AND the data retrieval in my applications.

Cheers,

[FireStorm9]

peterlaursen wrote on Sep 29 2006, 12:25 PM:

We have now studied your code.

Quite a lot of small things that we missed is there.

We will definitely try to 'put that in' next week before RC1 release.

No worries, just trying to share!

🙂

Cheers,

-=FireStorm

[FireStorm9]

peterlaursen wrote on Sep 28 2006, 02:37 PM:

We will definitely look into this tommorrow!

We will 99% also release beta5 tomorrow ourselves. It will probably be too late to include your patches in this one (I hope that there is not too much 'crossover'). But they can go into RC1 ..

I shall ask Manoj about the diff's are an OK way o coomunication or there is some better method.

To submit patches yourself to Google you will have to be a 'project member'.

Ok, thanks! Whatever works best for you guys.

-=FireStorm

[FireStorm9]

peterlaursen wrote on Sep 11 2006, 04:52 AM:

Thanks ..

Manoj and the team just arrived at office. Right now they are looking into the 'beta-sillies' that I reported last night. Hope they'll get time to look into this today too!

I figured out the diff comand (just like cvs), so here is the attached svn diff for my source tree.

Thanks,

[FireStorm9]

peterlaursen wrote on Sep 11 2006, 03:18 AM:

… that was what we were supposed to work on this week!

Though I personally might think that a setting for EACH of those is too much.

DATA and RESULTs could be the same. Messages and History too.

BTW: do not forget the BLOB-viewer! 🙂

.. I think it would be OK if the settings for DATA also had effect on CREATE/ALTER TABLE etc ..

I hope you will contribute your code – it will of course be included in COMMUNITY!

Of course I'll contribute!!!

Here's the changes (pretty minor) NOTE: NO GUI FONT SELECTOR IS IN PLACE. But add the lines to your sqlyog.ini file like so:

Code:

[EditFont]
FontName=Consolas
FontSize=9
FontStyle=400
FontItalic=0
FontCharSet=0

[DataFont]
FontName=Consolas
FontSize=9
FontStyle=400
FontItalic=0
FontCharSet=0

[TabObject]
FontName=Consolas
FontSize=9
FontStyle=400
FontItalic=0
FontCharSet=0

[QueryTab]
FontName=Consolas
FontSize=9
FontStyle=400
FontItalic=0
FontCharSet=0

[TabHistory]
FontName=Consolas
FontSize=9
FontStyle=400
FontItalic=0
FontCharSet=0

[TabMessages]
FontName=Consolas
FontSize=19
FontStyle=400
FontItalic=0
FontCharSet=0

[TabResult]
FontName=Consolas
FontSize=19
FontStyle=400
FontItalic=0
FontCharSet=0

Then, the following files have been changed (I do not know how to tell using svn, only cvs, so here's the changes:)

EditorFont.h

Code:

Insert at line 50:
@param keyname: the keyname to get the font for

Change line 53 to:
static void SetFont(HWND hwndedit, wyBool fromini, wyChar * keyname);

EditorFont.cpp

Code:

Line 29 change to:
EditorFont::SetFont(HWND hwndedit, wyBool fromini, wyChar * keyname)

Lines 47-50 change to:
GetPrivateProfileString(keyname, “FontName”, “Courier New”, (LPSTR) font, 128-1, directory);
fontsize = GetPrivateProfileInt(keyname, “FontSize”, 9, directory);
fontitalic = GetPrivateProfileInt(keyname, “FontItalic”, 0, directory);
fontstyle = GetPrivateProfileInt(keyname, “FontStyle”, 0, directory);

Line 55 change to:
fontcharset = GetPrivateProfileInt(keyname, “FontCharSet”, DEFAULT_CHARSET, directory);

EditorTab.cpp

Code:

Line 308 change to:
EditorFont::SetFont(pceditorbase->m_hwnd, wyTrue, “EditFont”);

TabHistory.cpp (I was kinda lazy on this one, I didn't want to touch too much legacy code)

Code:

Add the following to lines at line 70:
// really change the font. The above sets the colors and all that jazz
EditorFont::SetFont(hwndedit, wyTrue, “TabHistory”);

Change line 92 to:
EditorFont::SetFont(m_hwnd, wyTrue, “TabHistory”);

TabMessage.cpp

Code:

Add at line 110:
fontheight = GetPrivateProfileInt(“TabMessages”, “FontSize”, 9, directory);

Change line 126 to:
GetPrivateProfileString (“TabMessages”, “FontName”, “Courier New”, fontname, SIZE_128-1, directory);

TabObject.cpp

Code:

Add at line 79:
// really really set the font……..
EditorFont::SetFont(hwndedit, wyTrue, “TabObject”);

Change line 100 to:
EditorFont::SetFont(m_hwnd, wyTrue, “TabObject”);

TabResult.cpp

Code:

Add at line 131:
fontheight = GetPrivateProfileInt(“TabResult”, “FontSize”, 9, directory);
Change line 145 to:
GetPrivateProfileString (“TabResult”, “FontName”, “Courier New”, fontname, SIZE_512-1, directory);

I may have missed a couple, but you'll get the gist of it pretty quickly when you look at the code. Basically, just make EditorFont.cpp accept a third paramter to the SetFont function and voila. 🙂

Cheers,

FireStorm

[FireStorm9]

I'm more interested in fixing some of the things that ***I've*** wanted!

DONE:

Like the ability to specify the font for EACH OF THE TABS:

Messages

Results

Objects

History

etc.

TODO:

Paste as INSERT ROW, etc. etc.

Work on some of the bugs listed in the Google code.

I love this stuff! 😀

@Angelo

The link for the SDK is:

http://www.microsoft.com/downloads/details…;DisplayLang=en

@peterlaursen

But if you WERE interested in adding the compiled by……..on the about dialog box, simply change the following line:

SetWindowText(GetDlgItem(hwnd, IDC_REGINFO), “”);

to

SetWindowText(GetDlgItem(hwnd, IDC_REGINFO), “Compiled by peterlaursen”);

(ConnectionCommunity.cpp line 63)

[FireStorm9]

Another update:

Downloaded and installed the VS Express edition,

Downloaded and installed the July Win2003 SDK

Added the include, lib, and bin paths from the SDK to the VS Express config

Re-downloaded the source from Google and compiled…………And it worked. 🙂

There are a couple of gotchas here: lots and lots of deprecated functions (security stuff that you can ignore for now), and the keywords.db is not found. I copied the keywords from my PRO directory install and it worked just fine.

Thanks tons!

[FireStorm9]

Anyone had success in building this yet?

Running VS C++ 6, got the gdiplus libraries installed, and get tons of these:

c:program filesmicrosoft visual studiovc98includegdiplusflat.h(329) : error C2955: 'iterator' : use of class template requires template argument list

followed by:

SQLYog.exe – 282 error(s), 0 warning(s)

Are there steps to take to simply unzip/compile?

Thanks!

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 11:13 PM:

OKOKOKOK .. I give up then … let us return to this later next week!

Ahhh come on!!!! 🙂

Have a good weekend!

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 09:21 PM:

“I changed it to “server default””

'server default' means that the server setting for max_allowed_packet is used.

What is the server 'max_allowed_packet' in your case?

(tool .. show .. variables will tell).

What happens if you set the BULK sixe yourself to – say – '200' ?

show variables like 'max_allowed_p%';

Code:

Variable_name Value
—————— ——-
max_allowed_packet 1047552

Set to custom: 512

Same result.

Thanks,

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 02:58 PM:

tools … preferences … General TAB.

What is the setting for 'Max packet Size' on your system?

If it is = (zero) or very low that woluld explain!

http://webyog.com/faq/24_101_en.html

I checked and it was indeed set to custom: 8.

I changed it to “server default” and got the same result (complete sql statements).

I restarted SQLYog just in case, but STILL got the same results.

Thanks!

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 12:17 AM:

@FireStorm9

Now if you are sure that you do not get BULKs when you specify it, we will have to find the reason for difference!

I am sure. Please see the attached files for selection, result, and version information.

The connection is to a Linux server on my local lan, i.e. no ssh tunneling or anything special.

If there's anything I can do to to help I'd love to!

Thanks!!!

[attachment=506:attachment]

[attachment=509:attachment]

[attachment=510:attachment]

[FireStorm9]

I can't speak for Mac but I run it on Fedora Core 5 with wine and it runs great!

[FireStorm9]

You guys are good!!!!!!

Best,

-=Fire

[FireStorm9]

peterlaursen wrote on Jun 8 2006, 11:04 PM:

1)

Did you check program help .. keyboard shortcuts:

Ctrl+B Set Focus On Object Browser

Ctrl+E Set Focus On SQL Window

Ctrl+R Set Focus On Result Window (focusses on the last selected TA:cool:

to switch RESULT/NMESSAGES/DATA/OBJECTS/HISTORY tabs use

Alt+1…n Select Nth Tab In Result Window

2)

I do not think I understand?! closes the BLOB-viewer here.

1) Thanks for the quick reply!!! I thought there would have to be something somewhere……Thanks for setting me straight.

2) I still stand by what I said…….For me (xp pro, sqlyog 5.12BETA RC) ESC does not close the blob viewer. I'll check for an update and see what's up.

–Update– Just noticed I was a couple versions behind. Downloaded 5.14 B2 and was able to duplicate your findings and mine: When clicking on a NULL BLOB field, hitting escape does close the box if “Set to Null” is checked. If there's pre-existing data in the field, hitting escape does nothing.

Cheers,

-=Fire

[Author]

Posts