Re: LPEX bug?

[Paul Bailey <PabloMotte+Midrange@xxxxxxxxx>]

I have seen this before, and I've just reproduced the unexpected behavior
in RDi 9.5.1.

I turn off the auto SQL formatting usually because it keeps interfering
while I'm typing a SQL statement in, to the extent that it will sometimes
combine the following RPG line into the SQL statement if I press enter
before adding a semi-colon, and then it becomes impossible to create a
new-line.

For example (RDi 9.5.1) tick all the RPGLE SQL formatting options in the
preferences. In a /FREE section type EXEC SQL on a blank line before an RPG
line, then press ENTER but you won't get any new-lines. Press ENTER again,
maybe ALT-S (split line) a few times, add a semi-colon to the EXEC SQL and
see if that helps (it doesn't!) The only way to get it working properly is
to type a complete valid SQL statement on the same line as the EXEC SQL and
end it with a semi-colon. I just turn the auto-formatting off instead
because few SQL statements can fit on a single line in the LPEX editor! If
I want to format the SQL statements in a SQLRPGLE program source, I just do
all the work without auto-formatting, save it, then switch the
auto-formatting on (temporarily) and add a space to the end of each EXEC
SQL statement.

-Paul.


On 8 December 2016 at 21:20, Brian Parkins <goodprophet.bp@xxxxxxxxx> wrote:

> I think I’ve found a tiny – but irritating – bug in the LPEX editor when
> coding SQLRPGLE source. Anyone care to verify?
>
> Consider the following piece of simple code:
>
> ===========================
> Dcl-S ServerName Char(10);
>
> Dcl-S Message    Char(30) Inz('Server is:');
>
> EXEC SQL
>   VALUES Current_Server INTO :Servername;        // Line 1
>
> Message = %TrimR(Message) + ' ' + ServerName;    // Line 2
>
> Dsply Message '*REQUESTER';
>
> *InLR = *On;
> ===========================
>
> - From the RDi menu bar select, Window > Preferences
> - Select the preference for, Remote Systems > Remote Systems LPEX Editor >
> IBM i Parsers > ILE RPG > Free-form SQL Formatting
> - Tick the choice for Automatic Uppercasing, (I also have Style:
> Custom/Uppercase/Initial Character selected)
> - Click Apply and OK
>
> CASE A). UNEXPECTED BEHAVIOUR
> In the above source, position the cursor immediately before the ‘//’ in
> Line 1.
> Press ENTER a few times:
> The cursor moves on to the next line and stays fixed in that position; at
> each subsequent press of ENTER, new lines are added AFTER the cursor line.
>
> CASE B). EXPECTED BEHAVIOUR
> Now position the cursor immediately before the ‘//’ in Line 2.
> Press ENTER a few times:
> The cursor moves on to the next line; at each subsequent press of ENTER,
> new lines are added BEFORE the cursor line AND the cursor moves down.
>
> The Expected Behaviour can be achieved in CASE A). if the Automatic
> Uppercasing is deselected in the Preferences.
>
> (RDi 9.5.1 under Windows 7 and Windows 10.)
>
> Brian Parkins
> --
> 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.