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.


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


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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.