Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 6 of 6 total |
The " " character should be treated as a word breaker in SQL strings |
Tue, May 24 2011 6:11 PM | Permanent Link |
David Cornelius Cornelius Concepts | As kind-of a play of words on a recent topic in a different newsgroup, I
thought I'd voice a pet peeve of mine in EDB Manager. I rejoiced when word-jumping made it into EDB Mgr's SQL editor, but was dismayed to see that it treated a quoted string as one long word. Half of the code of procedures (or so it seems) is inside of EXECUTE IMMEDIATE statements. I'm constantly hitting Ctrl+arrow to quickly move along a line of text only to have it jump clear to the end of a line and start on the next line. Then I have to slowly cursor back to the position I want or (horrors!) take my hand OFF the keyboard and actually use the mouse! I hope you can tell I'm not terribly worried about this, but I've never seen any text editor before that ignored spaces in quoted sections, and I'd be delighted to see this "corrected." David Cornelius Cornelius Concepts |
Wed, May 25 2011 3:35 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | David
I obviously do more double click word selection than you do. I can live with ctrl-arrow but double click to select a word and you get everything. I think we should shoot the author!!!!!! Roy Lambert |
Wed, May 25 2011 1:23 PM | Permanent Link |
Adam Brett Orixa Systems | I Thoroughly agree that ctrl arrow _must_ jump words, not whole strings. It is one of the "features" of EDBMgr which drives me crazy, as I do a lot of SQL editing.
I end up cutting each Exec Immediate out into a SQL Statement so I can "jump around" it to get it right & then cut it back into the script once I have got it right. A really cool feature would be to be able to select segments of a SQL Script & run a prepare just on this segment ... that's another annoyance of the SQL Script editing environment, it doesn't "drill into" each Exec Immediate segment during the prepare ... so you never know whether its written right. Adam |
Thu, May 26 2011 3:13 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>A really cool feature would be to be able to select segments of a SQL Script & run a prepare just on this segment ... that's another annoyance of the SQL Script editing environment, it doesn't "drill into" each Exec Immediate segment during the prepare ... so you never know whether its written right. It already has this feature - its called cut'n'paste Roy Lambert |
Fri, May 27 2011 12:34 AM | Permanent Link |
David Cornelius Cornelius Concepts | I totally agree on the SQL Script thing as well. I have do a lot with SQL
Server on other projects and it's SOOOO convenient in the middle of a long procedure to just highlight a string and hit F5 to execute just that one line without having to copy/paste or comment out other sections of the script. David Cornelius Cornelius Concepts |
Tue, May 31 2011 3:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< A really cool feature would be to be able to select segments of a SQL Script & run a prepare just on this segment ... that's another annoyance of the SQL Script editing environment, it doesn't "drill into" each Exec Immediate segment during the prepare ... so you never know whether its written right. >> You can do that now in a normal (not script) window. Just pop in the various SQL statements that you want to run, and click on the left-hand gutter to select which statements you want to execute. When you hit F9 to execute them, it will only execute the selected statements. I could never really do a selective execution of scripts. Remember, scripts are a whole "program" by themselves, not just a serious of SQL statements like with DBISAM. Think of Delphi, for example: do you think it would be possible to selectively execute only a portion of the code in a unit ? -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |