|
On 5/11/2015 5:16 PM, Terry Hertel wrote: > Then it seems like I always have to remove the space(s) between the SQL "keyword(s)" (Select, When, Order By, Group By, etc.) and the rest of the statement to get RDi to quit reformatting the code, even though I have all the preferences for Free-form SQL formatting unchecked). I only have 'indent' checked; RDi 9.1.1.1 doesn't reformat the SQL for me. > So, can I develop in Navigator, copy it to Notepad++, and then copy from there to RDi to resolve these formatting issues? That's too much tinkering for me; I manage to turn perfectly working SQL into typo-gibberish far too often. Others may be better at manipulating text than me though. Anyway, when I'm developing SQL in Navigator I just put 8 leading spaces in the SQL. I also have a 'ruler' line that I use to make sure I don't accidentally go past column 76. The copy/paste goes swimmingly after that. -- --34567890123456789012345678901234567890123456789012345678901234567890123456 --buck
As an Amazon Associate we earn from qualifying purchases.
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.