Icon View Thread

The following is the text of the current message along with any replies. You may reply to this message or any of the other messages by clicking on the reply option next to the message that you wish to reply to.
Messages 1 to 10 of 24 total
Thread Annoyances and 1 real bug in EDBMgr
Thu, Jun 9 2011 7:27 AMPermanent Link Log in to reply

Adam Brett

Tropical Wholefoods

EDBMgr is a good product ... but ... there was bound to be a bug after that start to a post!

I write this thread just to point out some little things which would be nice to update in the EDBMgr ...

MAJOR BUG

From time to time when viewing the SQL definition for a VIEW in the Properties tab of the EDBMgr the wrong SQL is shown. This is pretty scary, as you often see SQL for some other randomly shown view, and then immediately think that your SQL is wrong.

The way round this is to write a Query on the VIEWS table:

SELECT Name, Definitions FROM Information.Views ORDER BY Name

and view the SQL there ... it is always right.

This may partly be an issue with the number of views in my DB, there are about 100, so maybe something is getting muddled in the EDBMgr in this situation.

I can cope with it, but if I give the EDBMgr to other users they will get very confused.

MINOR BUGS / ANNOYANCES

1. The operation of the SQL Editing Memo is a bit of a pain, common key-presses such as CTRL + BACK_ARROW jump around the script / statement annoyingly when the script includes 'strings'.

2. If you click on an empty script and paste the text pastes in from the screen location you clicked on, not from the top of the memo.

3. The SQL Editing Memo handles SELECTION of  text in a weird way, often selecting (in blue) text when you click on the screen for the first time. It must be holding a "previous" screen location for the cursor & assuming that the user wants to select between the 2 points, but I don't.

4. It is a bit too easy to randomly set break-points in the SQL Editing memo, when actually you are just selecting a piece of SQL to cut & paste to use elsewhere.

5. When reviewing a MEMO / CLOB field in a table I would prefer that the edit window which opened was not MODAL, so I could go to other TABs in the EDbMgr and compare the contents in the MEMO with other data ...
Thu, Jun 9 2011 4:12 PMPermanent Link Log in to reply

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< From time to time when viewing the SQL definition for a VIEW in the
Properties tab of the EDBMgr the wrong SQL is shown. This is pretty scary,
as you often see SQL for some other randomly shown view, and then
immediately think that your SQL is wrong. >>

Hmm, if you get any more information on this, please let me know.  It should
always show the correct SQL for the object that you have selected.  It may
have to do with selecting via the treeview vs. selecting via the listview,
but I just tried it here several different ways and can't reproduce the
issue.

<< 1. The operation of the SQL Editing Memo is a bit of a pain, common
key-presses such as CTRL + BACK_ARROW jump around the script / statement
annoyingly when the script includes 'strings'. >>

Common complaint, but sticking to my guns on this for now.

<< 2. If you click on an empty script and paste the text pastes in from the
screen location you clicked on, not from the top of the memo. >>

Are you right-clicking or left-clicking ?

<< 3. The SQL Editing Memo handles SELECTION of  text in a weird way, often
selecting (in blue) text when you click on the screen for the first time. It
must be holding a "previous" screen location for the cursor & assuming that
the user wants to select between the 2 points, but I don't. >>

Are you sure that you don't have the shift key pressed when you click in the
window ?

<< 4. It is a bit too easy to randomly set break-points in the SQL Editing
memo, when actually you are just selecting a piece of SQL to cut & paste to
use elsewhere. >>

Are you using an older version of the EDB Manager ?  This was fixed recently
in the last few months.  I can't add a breakpoint without clicking in the
gutter, and then making sure that I'm still in the gutter when I release the
mouse.  If you move out of the gutter, or in and then out of the gutter, a
breakpoint won't be placed.

<< 5. When reviewing a MEMO / CLOB field in a table I would prefer that the
edit window which opened was not MODAL, so I could go to other TABs in the
EDbMgr and compare the contents in the MEMO with other data ... >>

I'll see what I can do.  I've considered making this something that is
docked into the window.

--
Tim Young
Elevate Software
www.elevatesoft.com
Fri, Jun 10 2011 4:14 AMPermanent Link Log in to reply

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


><< 1. The operation of the SQL Editing Memo is a bit of a pain, common
>key-presses such as CTRL + BACK_ARROW jump around the script / statement
>annoyingly when the script includes 'strings'. >>
>
>Common complaint, but sticking to my guns on this for now.

Just remind me what are your guns?

><< 2. If you click on an empty script and paste the text pastes in from the
>screen location you clicked on, not from the top of the memo. >>
>
>Are you right-clicking or left-clicking ?

I get this when left clicking. I would also add that the memo doesn't pick up focus when tabbing between it and say the IDE. I have to specifically click into the memo to be able to paste.

><< 4. It is a bit too easy to randomly set break-points in the SQL Editing
>memo, when actually you are just selecting a piece of SQL to cut & paste to
>use elsewhere. >>

That used to be an annoyance, especially when selecting text, but I haven't noticed it for a while.

><< 5. When reviewing a MEMO / CLOB field in a table I would prefer that the
>edit window which opened was not MODAL, so I could go to other TABs in the
>EDbMgr and compare the contents in the MEMO with other data ... >>
>
>I'll see what I can do. I've considered making this something that is
>docked into the window.

Don't forget my request for a close button top right Smiley

Roy Lambert
Fri, Jun 10 2011 3:51 PMPermanent Link Log in to reply

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Just remind me what are your guns? >>

My guns are that I wrote it specifically to select entire strings based upon
the tokenized version of the SQL.

<< I get this when left clicking. I would also add that the memo doesn't
pick up focus when tabbing between it and say the IDE. I have to
specifically click into the memo to be able to paste. >>

I'm not sure if we're using the same EDB Manager - the editor retains focus
in all cases where I switch between the EDB Manager and another application,
or switch between editor windows.  Did the editor actually have focus before
you switched away from the EDB Manager ?

<< Don't forget my request for a close button top right Smiley>>

I won't. Smile


--
Tim Young
Elevate Software
www.elevatesoft.com
Sat, Jun 11 2011 3:35 AMPermanent Link Log in to reply

Uli Becker

Tim,

> My guns are that I wrote it specifically to select entire strings based
> upon the tokenized version of the SQL.

As I poted here before: for me it's really difficult to work with the
sql-editor because of that.
I copy words from a string quite often and it should be possible to
select a word with a double click.
This is common behaviour (e.g. in Delphi).

Please think about changing that.

Regards Uli
Sat, Jun 11 2011 8:18 AMPermanent Link Log in to reply

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

><< Just remind me what are your guns? >>
>
>My guns are that I wrote it specifically to select entire strings based upon
>the tokenized version of the SQL.

From that I guess a quoted string is a token. OK annoying but I've sort of become accustomed to swear and swipe Smiley

><< I get this when left clicking. I would also add that the memo doesn't
>pick up focus when tabbing between it and say the IDE. I have to
>specifically click into the memo to be able to paste. >>
>
>I'm not sure if we're using the same EDB Manager - the editor retains focus
>in all cases where I switch between the EDB Manager and another application,
>or switch between editor windows. Did the editor actually have focus before
>you switched away from the EDB Manager ?

Try this
- New sql window - start typing - its fine - the memo picks up focus and shows what you've typed.
- New sql window - ALT-TAB to another app, select some text and copy to clipboard - ALT-TAB back to EDBManager and press ctrl-v - result nada. Click into the memo and press ctrl-v and it works.

So "Did the editor actually have focus before you switched away from the EDB Manager ?" Answer: dunno. I sort of assume so since I can type into it without specifically clicking into it.

><< Don't forget my request for a close button top right Smiley>>
>
>I won't. Smile

Yeah Smiley

Roy Lambert
Sat, Jun 11 2011 3:32 PMPermanent Link Log in to reply

Adam Brett

Tropical Wholefoods

OK: Since we are getting into the swing of things suggesting changes for the EDBMgr! Smile

*** I would really like New SQL Scripts to be called NewScript1, NewScript2, NewScript3 and New SQL Statements to be called New1, New2, .... it would really help with keeping track of them.

I often have several SQL editing TabPages / windows open in the EDBMgr, when each SCRIPT and SQL page is just called "New" it is hard to locate which is which.

*** Views, Tables, Functions etc., in the tree _really_ should display alphabetically. Right now they show in creation order. Once you have 50+ of each it gets really hard to find each one! I end up opening a SQL statement window with

SELECT Name, Definition FROM INFORMATION.Views ORDER BY Name

in it ... which basically means I ignore the tree, which is a pity. (Also it means I need another "New" PageTab open, which is hard to locate!)

*** I honestly don't agree on the SQL Memo ALT / CTRL behaviour. I am often leaping from Delphi -> EDBMgr, or from Notepad or other text entry location. the more similarity there is between _all_ the entry points the better.

i.e. it is brilliant that the "CTRL + I" and "CTRL + U" Indent and Unindent ... just like Delphi ... so I can do it in both places without having to think.

*** I am definitely seeing "not up to date" versions of VIEWS etc., in my EDBMgr it is 2.05 build 1, I will download a newer version if there is one!

Adam
Sun, Jun 12 2011 4:03 AMPermanent Link Log in to reply

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam

>*** I would really like New SQL Scripts to be called NewScript1, NewScript2, NewScript3 and New SQL Statements to be called New1, New2, .... it would really help with keeping track of them.

Agreed

>*** Views, Tables, Functions etc., in the tree _really_ should display alphabetically. Right now they show in creation order. Once you have 50+ of each it gets really hard to find each one! I end up opening a SQL statement window with

I think I can help here - Edit - Preferences - Explorer - Sort Order

I would also like to add in one of my own - Put the paths for the current config & catalog up on the forms caption.

When I first asked for something like this the path for the database was visible, now with the new Log Messages I have to scroll to see it.

Roy Lambert [Team Elevate]

Sun, Jun 12 2011 4:55 AMPermanent Link Log in to reply

Uli Becker

Roy,

> I think I can help here - Edit - Preferences - Explorer - Sort Order

In addition: you can sort every item individually by clicking the
order-icon in the toolbar above the tree.

Uli
Mon, Jun 13 2011 2:57 AMPermanent Link Log in to reply

Tiago Ameller

Menorca Zeros i Uns SL

Avatar

Hi to all,

I just can say I only use edbmgr editor for little changes, for medium to large writing I copy/paste text to editpadpro from Jan Goyvaerts Software. Editing in edbmgr is annoying for me.
Page 1 of 3Next Page
Jump to Page:  1 2 3
Image