Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 14 total
Thread DB mgr editor suggestion
Thu, Apr 16 2009 10:08 PMPermanent Link

"James Relyea"
I'm not sure if anyone suggested this, so here goes:

Could an updated SQL text editor be considered in the future?

I am a stickler with properly formatted code. I like line wrapping, no extra
white space, and a left margin to stay indented after I hit enter. It drives
me a little batty having to hit tab 3x for each line so it looks "pretty"
and formatted nicely.

Smile
jr

Fri, Apr 17 2009 12:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

James,

<< Could an updated SQL text editor be considered in the future?

I am a stickler with properly formatted code. I like line wrapping, no
extra white space, and a left margin to stay indented after I hit enter. It
drives me a little batty having to hit tab 3x for each line so it looks
"pretty" and formatted nicely. >>

Sure, I'll add it to the list.  However, could you elaborate on "line
wrapping and no extra white space" ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Apr 17 2009 10:07 PMPermanent Link

"James Relyea"
> Sure, I'll add it to the list.  However, could you elaborate on "line=20
> wrapping and no extra white space" ?

Sure... I'll try:

Line Wrapping:  Instead of the code editing being 1 long line, it would =
wrap to the next line automatically when the right margin is reached.=20
One example of this line wrapping behavior would be on your web site: =
http://www.elevatesoft.com/prodinfo?action=3Dlist  Open it then reduce =
the width of the IE window. The entire page wraps as the browser window =
resizes allowing all of the text to be read without any horizontal =
scrolling until the window becomes too narrow.

Notepad does the same (menu Format>Word Wrap to toggle it on and off). =
VS supports it as an option too and adds a visual glyph to indicate the =
line wraps.

The benefit lets us read our entire block of code without needing to =
scroll horizontally back and forth to view segments. I'm in the habit of =
hitting enter now but I'd prefer to just type without thinking of the =
right margin or line size.


Extra White Space: Basically I can put the cursor any place in the =
window and start typing even though i'm no where around my code. I find =
myself constantly flipping between windows and when I flip back to any =
EDB Mgrs running the cursor is put where I click the window instead of =
where I left it. Won't happen with ALT + Tab but does when using the =
mouse to put the focus back on any EDB Mgr with code being edited. I run =
30+ apps at any given time accross 3 displays so  ALT + Tab doesn't work =
out so well. So I click on the "wanted app" because it's always in view. =
EDB moves my cursor from where I was typing to where I clicked because =
it has extra virtual whitespace. VS & Winbatch both have a toggle on/off =
but leave it off by default.

For another example of how why I added dropping the virtual white space =
as a request is because I'm used to a MS Word, VS, Notepad, IE URLs etc =
behavior. With those, if you click past the end of a line, the cursor =
lands @ the end of the line. EDB MGR puts the cursor where you clicked =
instead of @ the line end.

There are 2 benefits:
1. we would be able to blindly click past a line end and have the cursor =
land on next character position in the line and keep on typing, like =
most other Win apps do
2. we could put focus on the EDB Mgr window, not move the cursor from =
where it was and keep on typing, also like most Win apps behave



I hope these details helps explain it better.

Thanks Tim!

Smile
jr
Tue, Apr 21 2009 1:54 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

James,

<< I hope these details helps explain it better. >>

Yes, thank you.   You'll be interested to know that the Delphi IDE does both
of those things in the same manner as the EDB Manager, hence their origins.
Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Apr 22 2009 9:21 PMPermanent Link

"James Relyea"
> You'll be interested to know that the Delphi IDE does both of those things
> in the same manner as the EDB Manager, hence their origins.

eeeeeewwwwwwwwww.Coming from a Windows world of apps & VB4 ->VS2008, I guess
Delphi would kill me.

Out of curiosity, VS allows the whitespace & line wrapping to be turned on &
off. Does Delphi too?
(hint hint maybe EDB mgr could too cuz all it is is a text editor)



Smile
jr

Thu, Apr 23 2009 4:56 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

James,

<< eeeeeewwwwwwwwww.Coming from a Windows world of apps & VB4 ->VS2008, I
guess Delphi would kill me.

Out of curiosity, VS allows the whitespace & line wrapping to be turned on
& off. Does Delphi too? >>

Yes, absolutely.

<< (hint hint maybe EDB mgr could too cuz all it is is a text editor) >>

Well, it's a little more than just a simple text editor. SmileyTake a look at
the source code in the edbutilcomps.pas unit some time if you want to know
how difficult it is to write a syntax-highlighting SQL editor with debugging
and context-sensitive help/tooltip expressions.  It's about 5000 lines of
code.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Apr 23 2009 9:22 PMPermanent Link

"James Relyea"
> syntax-highlighting SQL editor with debugging=20
> and context-sensitive help/tooltip expressions.  It's about 5000 lines =
of=20
> code.


Oh, no... I'm not asking for any thing like intellisense at all. I'm =
working just fine without it.

All I'd really love to use is a text editor that includes line wrapping, =
no virtual white space, keeps my cursor where I put it when I come back =
to that window, & keeps my left margins lined up so when I indent them, =
they stay indented 'cuz it keeps my code-- well-- nice and pretty Smile)Smile

Does that help?

Smile
jr

Thu, Apr 23 2009 10:20 PMPermanent Link

"James Relyea"
I misinterpreted this. Yes, I do find that quite helpful when coding by =
the way. I thought of VS's Intellisense when I replied back- that I =
don't need. Sorry about that.
 > syntax-highlighting SQL editor with debugging=20
 > and context-sensitive help/tooltip expressions.  It's about 5000 =
lines of=20
 > code.


 >Oh, no... I'm not asking for any thing like intellisense at all. I'm =
working just fine without it.
Fri, Apr 24 2009 2:43 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

James


If you can come up with a set of rules that can be used to format sql I'll be happy to try and produce a stand alone utility which will do the formatting and we might be able to persuade Tim to incorporate it into EDBManager not as a live formatting option but more like the code formatter in GExperts.

Roy Lambert
Fri, Apr 24 2009 3:04 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

James,

<< All I'd really love to use is a text editor that includes line wrapping,
no virtual white space, keeps my cursor where I put it when I come back to
that window, & keeps my left margins lined up so when I indent them, they
stay indented 'cuz it keeps my code-- well-- nice and pretty Smile)Smile>>

The auto-indent and no white space features are easy, so I can do them
pretty quickly.  The word-wrapping is a different story, and will require
quite a bit more time.

--
Tim Young
Elevate Software
www.elevatesoft.com

Page 1 of 2Next Page »
Jump to Page:  1 2
Image