Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread A couple of minor EDBMgr suggestions
Thu, Jan 31 2013 3:07 PMPermanent Link

Barry

1) In the Object Tree of EDBMgr, if I double click a tree node (like a table name) to select the table and then open the table from the pane, the node font changes to bold but the color changes to white text on a grey background and is difficult to read. Why can't the selected node text stay black on a grey background when focus leaves the tree?

2) When executing a query in the New.Sql pane, it would be nice if the status bar of the Result Set page (right of navigator) had an icon that displays the sensitivity of the query. When the query is sensitive, the icon would show "Browsing Sensitive" with a green background. Or a red Browsing "Insensitive" icon when the query is insensitive. Then we would know right away the sensitivity of the query. (The color would make it stand out better.) The execution plan sometimes says "The result set was sensitive" when in fact it isn't. So EDBMgr will have to check the sensitivity after the query has executed and display the correct icon next to the navigator at the bottom of the Result Set page.

Barry
Thu, Jan 31 2013 4:51 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Barry,

<< When executing a query in the New.Sql pane, it would be nice if the status bar of the Result Set page (right of navigator) had an icon that displays the sensitivity of the query. When the query is sensitive, the icon would show "Browsing Sensitive" with a green background. Or a red Browsing "Insensitive" icon when the query is insensitive.
Then we would know right away the sensitivity of the query. (The color would make it stand out better.) >>

While it doesn't, it's still easy to spot if the result set is updatable or not, just look at the navigator buttons next to the suggested tag, if there are Delete, Update and Insert buttons it is, if they are missing - it isn't. Easy and visible, big and colourful enough, more than any tag.

<<The execution plan sometimes says "The result set was sensitive" when in fact it isn't. So EDBMgr will have to check the sensitivity after the query has executed and display the correct icon next to the navigator at the bottom of the Result Set page.>>

If the query involves derived tables it might happen that the query or some of the query expressions are sensitive at some level but the final result is not...
You are right, it may be confusing and unclear if the final result is sensitive or not. I have no idea how difficult it is to correctly evaluate if the final result is sensitive in advance on those complex cases... I always vote for less code in the engine if the result is not worth the additional code, but that's something i cant even vote for as I have no idea how difficult that would be to implement.

--
Fernando Dias
[Team Elevate]

Fri, Feb 1 2013 12:25 AMPermanent Link

Barry

Fernando,

>While it doesn't, it's still easy to spot if the result set is updatable or not, just look at the navigator buttons next to the suggested tag, if there are Delete, Update and Insert buttons it is, if they are missing - it isn't. Easy and visible, big and colourful enough, more than any tag.<

Good tip. I didn't notice that. Smile

Barry
Fri, Feb 1 2013 1:04 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Barry,

<< 1) In the Object Tree of EDBMgr, if I double click a tree node (like a
table name) to select the table and then open the table from the pane, the
node font changes to bold but the color changes to white text on a grey
background and is difficult to read. Why can't the selected node text stay
black on a grey background when focus leaves the tree? >>

This is standard behavior for the TTreeView/Windows - I'm not modifying this
to make it behave that way, and the behavior is related to the focus state
of the node.

<< 2) When executing a query in the New.Sql pane, it would be nice if the
status bar of the Result Set page (right of navigator) had an icon that
displays the sensitivity of the query. When the query is sensitive, the icon
would show "Browsing Sensitive" with a green background. Or a red Browsing
"Insensitive" icon when the query is insensitive. Then we would know right
away the sensitivity of the query. (The color would make it stand out
better.) The execution plan sometimes says "The result set was sensitive"
when in fact it isn't. So EDBMgr will have to check the sensitivity after
the query has executed and display the correct icon next to the navigator at
the bottom of the Result Set page. >>

Please see Fernando's answer - it covers things nicely.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Feb 4 2013 3:55 PMPermanent Link

Barry

"Tim Young [Elevate Software]" wrote:

<This is standard behavior for the TTreeView/Windows - I'm not modifying this
to make it behave that way, and the behavior is related to the focus state
of the node.>

Yes, I realize that making the node text unreadable when the tree loses focus is a Microsoft "feature". Smile

I was wondering if you could override it (change the style?) so the node text is still readable when the tree loses focus. Either darken the node background  to make the white text more readable, or darken the text. As it stands now it the white text on a light grey background is pretty much unreadable unless I have my nose pressed to the screen.

Barry
Wed, Feb 6 2013 3:54 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Barry,

<< I was wondering if you could override it (change the style?) so the node
text is still readable when the tree loses focus. Either darken the node
background  to make the white text more readable, or darken the text. As it
stands now it the white text on a light grey background is pretty much
unreadable unless I have my nose pressed to the screen. >>

The issue is that the theming can cause the colors to be different depending
upon how Windows is skinned.  I'm not sure if I would be shooting someone
else in the foot by fixing the colors to a specific set of colors.

Tim Young
Elevate Software
www.elevatesoft.com


Image