Re: Notepad++

It almost sounds like you might be adding "tab" characters into your code in navigator.

Before pasting SQL into RDI, I usually paste it into a text editor and run a script to convert tabs to spaces.

If you paste text into RDI that contains tab characters, sometimes the code will appear to "shift" while you are cursoring through it.

Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.


-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Terry Hertel
Sent: Monday, May 11, 2015 3:17 PM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] Notepad++

I'm not familiar with Notepad++. Will it resolve the copy and paste issue going from System i Navigator SQL to RDi? I do almost all of my SQL development in Navigator and after I have it working I copy and paste it into RDi. RDi shifts everything after the first line all the way to the left so I have to block the lines and do Alt/F8 to shift the code where I want it. 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). So, can I develop in Navigator, copy it to Notepad++, and then copy from there to RDi to resolve these formatting issues?