Re: SQL Auto formatting

By default, the numpad Enter will split the line at the current location.

In the editor's command line, issue 'query keyAction.numpadEnter' and
'query keyAction.enter' to see.

If you want the numpad Enter to behave the same as the normal Enter, you
can go to the LPEX Editor>User Key Actions preference page and define
numpadEnter to invoke enterRPG.

Thanks,
Eric





Eric Simpson
Rational Developer for i - Rational Developer for
AIX and Linux - Rational Developer for Power
IBM Software Group - Canada Lab
Phone: 905-413-3226 (T/L: 313-3226)
esimpson@xxxxxxxxxx







From: Stuart Rowe <rowestu@xxxxxxxxx>
To: "Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries" <wdsci-l@xxxxxxxxxxxx>
Date: 02/17/2017 12:40 PM
Subject: Re: [WDSCI-L] SQL Auto formatting
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



Thanks Vern, I have the latest version all updated and do not use **free
due to being tied to 6.1, just "old school" /free. I'm aware of the
regular RPG formatting options and turned them all off too but that didn't
change anything in either SQL or regular. I have turnd off every
formatting setting in all sections and still odd formatting occurs when I
type a line and press the keypad enter, not the other Enter key. Luckily,
ctrl-shift-F formats it back to be correct. I don't use SQLRPGLE very
often so I really didn't notice it till just now.

Stu





On Fri, Feb 17, 2017 at 10:18 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Hi Stuart

There's another preference section for auto-formatting RPG istelf - that
would affect both RPGLE & SQLRPGLE members, however.

If you are in a more-recent version of RDi, there might be the fully-free
formatting, as well - where you put **free in position 1of line 1.

Or you might need to upgrade, as there have been some issues in prior
releases.

HTH
Vern


On 2/17/2017 9:46 AM, Stuart Rowe wrote:

Any idea how to stop auto formatting in SQL RPGLE members? It's driving
me
nuts (well, more nuts).

I have turned off every setting for "Free-form SQL Formattiing" but it
still formats my NON-SQL code (regular old RPG code) in SQLRPGLE

members.

It does it poorly as well -- just shoves everything to beginning of

line.

--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.