SQR Editor - Using Noepad++ for SQR development

NOTEPAD++ is one of the editor you can use it to write & run a program from there it self . See the following steps to do it .

1) Download and install NOTEPAD++ from its website 

2) First make sure that you have your complete command line flag information used to execute sqr program.It looks some thing like

In the case of MSS

 C:\HRMS90\bin\sqr\MSS\BINW\sqrw.exe  pay143.sqr PS_HOME/Username/pwd -zifc:\hrms90\sqr\pssqr.ini -ic:\hrms90\sqr\ -oc:\temp\test.log -ziv -PRINTER:PD 

In the case of ORACLE
After the report name you has to mention the database connectivity in the following format 

UserName/Password@Database

3) Modify your flag information in such a way NOTEPAD++ can execute the current program 

  change your program name with $(FULL_CURRENT_PATH)
   i.e.   pay143.sqr with  $(FULL_CURRENT_PATH)

Finally it looks like

 C:\HRMS90\bin\sqr\MSS\BINW\sqrw.exe $(FULL_CURRENT_PATH) PS_HOME/Username/pwd -zifc:\hrms90\sqr\pssqr.ini -ic:\hrms90\sqr\ -oc:\temp\test.log -ziv -PRINTER:PD  

4) Open Notepad++ go to 
    Plugins -> Plugin Manager ->Show Plugin Manager
   Now click on the NppExec from the available Plugins and   Install
   Click on Yes when it prompts for restart option 

5) Now go to 
     Plugins ->NppExec ->Execute 
     Enter the above mentioned command there. Click on save
     Enter meaning full name  :: Run SQR:: 
     Click on OK

6) Now make this as a visible option.
    Go to Plugins ->NppExec -> Advanced Options
    Check on ' Place to the Macros submenu '
    Select Associated script : ' SQR Run '
    Visible option as ' Yes ' 

7) Finally restart your Notepad++ once to get changes affected . You can find the SQR Run option under the Macro menu .

Syntax Highlighting

1) Download the syntax highlighting sqr xml file from the following link  http://sdrv.ms/183gwWF

2) Open  C:\Program Files\Notepad++\plugins\APIs & paste the xml file over there . We can access the same file by searching %appdata% in the command line

3) Open NP -> Languages -> User Define Language
   Click on Create New -> Click on IMPORT -> Give the path  
   of SQR.XML in API folder

 4) Now automatically you will have SQR in your Language menu select that for highlighting the code . You can always change the highlighting colors in the same window

For UltraEdit It should look like 

C:\HRMS90\bin\sqr\MSS\BINW\sqrw.exe %F HRMS90/sa/sa -zifc:\hrms90\sqr\pssqr.ini -ic:\hrms90\sqr\ -oc:\temp\test.log -ziv -PRINTER:PD