Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread The " " character should be treated as a word breaker in SQL strings
Tue, May 24 2011 6:11 PMPermanent Link

David Cornelius

Cornelius Concepts

Avatar

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."  Smile


David Cornelius
Cornelius Concepts
Wed, May 25 2011 3:35 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 PMPermanent 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 Smiley

Roy Lambert
Fri, May 27 2011 12:34 AMPermanent Link

David Cornelius

Cornelius Concepts

Avatar

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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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
Image