Often I go to clients where the standard IDE for developing SQRs is Notepad.  Now this will work in a pinch but after staring at that for a few minutes I decided there had to be a better alternative.  With the budget of $0 and needing something immediately, the solution was Notepad++ and a custom language file.

 This solution will provide you with:

• Syntax Highlighting
• Syntax Folding ( Collapse Functions \ Procedures )
  
• Advanced Find \ Replace Functionality
• Tabbed Documents 

The setup is quite simple.

1. Download and Install Notepad++ 
2. Download my custom User Defined Language File (UserDefineLang.xml (35.43 kb))
3. Save the UserDefineLang.xml to your%appdata%\Notepad++ directory
4. If you had Notepad++, Close and Open it.
5. If you open an SQR file, you should see the syntax properly highlighted, if not go to the language menu and scroll to the bottom and choose SQR.

I have to give credit to some others for their work on the language files as for the most part I have copied and enhanced their version (SQR, PeopleCode,Cobol and PowerShell)
If you are looking for additional languages, the Notepad++ site or a google search should find it for you.

I'm going to follow this up with a few other useful things you can do with Notepad++ and PeopleSoft development.

Update 08-Apr-2009: Check out my new post on syntax checking and running a SQR from within Notepad++!

If you found this useful, please click and look at one of the ads on this page.  It's where I get the money for this site.  Thx 

 

 

Another alternative is you want to pay is:

 SQR Express  ( 30 day trial available ) 

 I've used it as well and it is very good and adds quite a bit of additional functionality.