> -----Original Message-----
> From: Roger Harris [Consultant] [mailto:RH...@th...]
> Sent: Friday, July 27, 2012 8:52 AM
> To: squ...@li...
> Subject: Re: [Squirrel-sql-users] SQuirreL deals badly with very long
> lines
>
> Have you tried using the Format SQL option: MENU Session > SQL Entry
> Editing > Format SQL (Ctrl+Alt+F) before you try navigating through the
> text?
That's essentially a different version of "preprocess these long SQL lines in an external text editor", within the same tool, but with less control over the formatting. I'm sure that prevents the problem, but that formatting algorithm often results in many more lines than I want.
> -----Original Message-----
> From: KARR, DAVID [mailto:dk...@at...]
> Sent: Friday, July 27, 2012 10:41 AM
> To: squ...@li...
> Subject: [Squirrel-sql-users] SQuirreL deals badly with very long lines
>
> When I'm navigating through the SQL editor in SQuirreL I have to be
> very careful when I have very long lines. I often have to work on
> queries that are 20k characters long. I often have to paste these
> queries in from other resources, and they are often a single line.
> I've learned that if I start at the beginning of the line and try to
> press the End key, SQuirreL will freeze, either for a very long time,
> or essentially forever, forcing me to kill the process. I often have
> to preprocess these long SQL lines in an external text editor, breaking
> them up into shorter lines, before I try to use them in SQuirreL.
>
> I don't have a specific test case yet.
>
> -----------------------------------------------------------------------
> -------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond.
> Discussions
> will include endpoint security, mobile security and the latest in
> malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
> -----------------------------------------------------------------------
> -------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond.
> Discussions
> will include endpoint security, mobile security and the latest in
> malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|