Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 24 total |
Annoyances and 1 real bug in EDBMgr |
Thu, Jun 9 2011 7:27 AM | Permanent Link |
Adam Brett Orixa Systems | 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 Roy Lambert |
Fri, Jun 10 2011 3:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 >> I won't. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jun 11 2011 3:35 AM | Permanent Link |
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 AM | Permanent Link |
Roy Lambert NLH Associates 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 ><< 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 >> > >I won't. Yeah Roy Lambert |
Sat, Jun 11 2011 3:32 PM | Permanent Link |
Adam Brett Orixa Systems | OK: Since we are getting into the swing of things suggesting changes for the EDBMgr!
*** 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
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 AM | Permanent Link |
Tiago Ameller Menorca Zeros i Uns SL | 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 3 | Next Page » | |
Jump to Page: 1 2 3 |
This web page was last updated on Friday, April 26, 2024 at 06:09 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |