Re: Autoformat SQL in RPGLE FREE

["Briggs, Trevor (TBriggs2)" <TBriggs2@xxxxxxxxxxx>]

Obviously, the problem is that you are writing a brand new SQLRPGLE
program and you're still using subroutines! :-)

Trevor Briggs
Analyst/Programmer
Lincare, Inc.
(727) 431-1246
TBriggs2@xxxxxxxxxxx
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Paul Bailey
Sent: Wednesday, April 09, 2014 8:39 AM
To: WDSCI-L@xxxxxxxxxxxx
Subject: [WDSCI-L] Autoformat SQL in RPGLE FREE

Hi,

I'm having a bad time entering a brand new SQLRPGLE program. When I
enter an EXEC SQL statement in my RPG (say, for instance, between a
begsr; and endsr;) and then press ENTER, (or DOWN, or otherwise try to
indicate I want to continue typing on the next line) the SQL
autoformatter sucks out all the whitespace between the EXEC SQL and the
endsr; and puts them both on the same line. And it keeps doing it after
every press of ENTER or DOWN! At least until the SQL statement is
complete, anyway. Obviously endsr; is not a valid SQL statement, so I
would expect the formatter to not do anything until it can parse the
line properly.

Anybody know if there is an option to stop this (turning off the
autoformatter is an option, but I'd prefer to keep using it to keep my
SQL statements properly formatted.)

Is there a quick way to turn the SQL formatter on and off? So maybe I
can turn it off, type a whole statement and turn it back on to format
it. Navigating the windows/preferences page for this option isn't ideal.


-Paul.


________________________________
Important, this email transmission and any files with it are strictly
confidential to the intended recipient and may be legally privileged.
Any views or opinions presented are solely those of the author and do
not necessarily represent those of BHSF. If you are not the intended
recipient, you must not copy, disclose or distribute its contents in any
way. If you have received this e-mail in error, please notify the sender
and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from
any virus but do not accept any responsibility once this e-mail has been
transmitted. You should scan any attachments for viruses. No contract
may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road,
Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500.
BHSF Limited is authorised by the Prudential Regulation Authority and
regulated by the Financial Conduct Authority and Prudential Regulation
Authority.