× 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 2017

Re: SQL Auto formatting


Hi Stuart,

I think that is an issue with the product. There was a discussion on the
RDi forum as well about it and a PMR was opened (
https://www.ibm.com/developerworks/community/forums/html/topic?id=3a48c2cd-9ed9-41ec-bf08-01a6546e0864&ps=25
).

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/27/2017 07:01 AM
Subject: Re: [WDSCI-L] SQL Auto formatting
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



Eric

I found a pattern for the errant relocation of the line in SQLRPGLE
members. It attempts to left-align the original line (the left side of the
split) with the line above it. Odd when that line is a compiler directive
(like /free). Even wierder is when it realigns the /free under the D in a
d-spec.

This is with all auto formatting and/or indenting settings turned off for
both RPGLE and SQLRPGLE. It occurs outside SQL statements in regular RPG
code.

Stu



On Sat, Feb 18, 2017 at 6:59 AM, Stuart Rowe <rowestu@xxxxxxxxx> wrote:

Thanks Mike, I turned off all those options years ago. Automatic
formatting is not to my taste.

Eric, split line is fine. Frankly it's what regular Enter should have
been doing all along, so I never use the regular Enter any more. It's
the
very first weird LPEX thing I noticed when WDSC came out. It's the first
thing I have to try explain to new users: why Enter does not split the
line
like in every other editor in the world.

Perhaps my original email was unclear: When I press numpad-Enter in an
SQLRPGLE member, the line on which I pressed numpad-enter is relocated.
Sometimes it slides all the way to the left (to column 8), but sometimes
it
slides to the RIGHT 2 spaces (I cannot identify a pattern), but it ALWAYS
moves. When I do the same in an RPGLE member, that line it is NOT
ALTERED
at all, it never moves. I can't seem to get the SQLRPGLE parser to stop
doing it.

I could understand the new line (the right side of the split) being moved
somewhere weird, or indented under the original line, but the relocation
of
the original line (the left part of the split) is what I do not
understand. This only occurs in SQLRPGLE members, not in RPGLE members.
That seems odd.

Stu




On Fri, Feb 17, 2017 at 1:13 PM, Eric Simpson <esimpson@xxxxxxxxxx>
wrote:


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.


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



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.