|
From: Alexandre P. <Ale...@ei...> - 2012-07-27 19:10:41
|
On Fri, July 27, 2012 at 2:45 PM, DAVID KARR wrote: > On Fri, July 27, 2012 at 8:52 AM, Roger Harris [Consultant] wrote: > > 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. And why exactly do you care how many lines is in your SQL after reformatting? You don't even need to look at it - make the SQL pane short. You did say that you are getting your SQL from external source, so presumably you are modifying it in your external source, too (I know I do: I develop all SQL in Notepad++ so that I always have a log of what I did - you know, belt and suspenders ;-) -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, Th, Fr) (718) 920-4885 (Tu & We) |
