|
Replies:
5
-
Pages:
1
-
Last Post:
Oct 28, 2009 3:48 PM
by: Gwen
|
|
|
Posts:
189
Registered:
8/7/07
|
|
|
|
Explain plan - Save To JPG
Posted:
Oct 23, 2009 12:25 AM
|
|
|
Hello,
In the explain plan interface, one can right-click in the "plan" pane and select "Save To JPG". The suggested file has a the .JPG extension, but its contents are a .BMP?
|
|
|
Posts:
30
Registered:
6/2/06
|
|
|
|
Re: Explain plan - Save To JPG
Posted:
Oct 26, 2009 8:46 AM
in response to: Radar Automation
|
|
|
Interesting, I did not notice this option before.
But it does not work for me anyway. After selecting a folder and a file name for the .jpeg file all I get is an error message:
11:27:55 AM Cannot open clipboard
and no image file.
|
|
|
Posts:
865
Registered:
11/19/07
|
|
|
|
Re: Explain plan - Save To JPG
Posted:
Oct 26, 2009 4:38 PM
in response to: Radar Automation
|
|
|
Hi Dominique,
Apologise if I'm clueless. I saved it as JPG. The Properties page shows the file type as JPG. How do you know the content is a bitmap?
Alexey not sure why it doesn't work for you. Screenshots please.
Gwen
|
|
|
Posts:
865
Registered:
11/19/07
|
|
|
|
Re: Explain plan - Save To JPG
Posted:
Oct 26, 2009 5:15 PM
in response to: Gwen
|
|
|
Hi Dominique,
I found out a way to check. Will raise a CR for it.
Cheers,
Gwen
|
|
|
Posts:
30
Registered:
6/2/06
|
|
|
|
Re: Explain plan - Save To JPG
Posted:
Oct 28, 2009 11:38 AM
in response to: Gwen
|
|
|
Okay, I think I figured it out...
Click "Save To JPG', type '1' in the file name field, click OK -- saves normally into 1.jpg file.
Click "Save To JPG', type '1.jpg' in the file name field, click OK -- "Cannot open clipboard' error.
Click "Save To XML', type '1.jpg' in the file name field, click OK -- saves normally into 1.jpg.xml file.
As I can see, the .jpg files created are really BMP.
1.jpg.old 8,341,614 bytes - file saved by SQL Nav
1.bmp 8,341,614 bytes - same file saved in Paint as BMP
1.jpg 177,173 bytes - same file saved in Paint as JPEG
The real JPEG file looks like this in HEX editor:
0000000000: FF D8 FF E0 00 10 4A 46 │ 49 46 00 01 01 01 00 60 ÿOÿà ►JFIF ☺☺☺ `
The file created by SQL Nav looks like this:
0000000000: 42 4D 6E 48 7F 00 00 00 │ 00 00 36 00 00 00 28 00 BMnH⌂ 6 (
|
|
|
Posts:
865
Registered:
11/19/07
|
|
|
|
Re: Explain plan - Save To JPG
Posted:
Oct 28, 2009 3:48 PM
in response to: ashmelev
|
|
|
Hi Alexey,
I tried typing '1.JPG' in the name field and later on opened using paint. It worked ok for me. What did you use to open the image?
The issue with sqlnav saving it as bmp will be addressed.
Gwen
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
