× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WDSCI-L
  3. February 2022

Re: Autoformat Exec SQL

Greg, I've never tried the formatting in RDi with tabs in the string - there is a formatter for SQL in RDi, and there are settings for it. It's a little different from what Jack is suggesting, but not that much.

You can also put your cursor in the statement in RDi and press Ctrl-Shift-F to format it - you should probably select the statement, to format only that statement - otherwise it will change the entire source, I find.

Enjoy!
Vern

On 2/4/2022 3:17 PM, Jack Woehr via WDSCI-L wrote:
Toss it into iACS Run SQL Scripts and format there and then paste it back.

On Fri, Feb 4, 2022 at 2:15 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

I recently pasted some SQL code into a source member. It must have
contained a mix of tabs and spaces for the indents.
When I click different places in the code, I can see the indents
"shift"... several lines move right.
If I click anywhere in the code section that moves, the rows "auto-align".




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.