OpenROAD external editor?
Paul White
Has anyone tried using vscode or textpad as a script editor? Something
like this?
II_W4GL_SYSTEMEDITOR=TRUE
II_EDIT="C:\Program Files\TextPad 4\Textpad.exe" -t"%t" "%f(%l)"
We are having trouble creating an efficient script editing / development
environment which is language and object sensitive
I recall seeing a presentation from Bodo demonstrating the use of
Eclipse with OpenROAD. I think it involved exportapp / importapp
interfaced with external source repositories.
Your tips and suggestions are greatly appreciated.
Thanks
&
Adrian Williamson
Hi Paul,
I used to use TextPad about 15 years ago but I moved onto Notepad++
I do recall having some difficulty in creating a functioning command line for OR to fill out with TextPad (I even bought a licence).
From an old VM I have I see this:
II_W4GL_SYSTEMEDITOR=TRUE
II_WINDOWEDIT="C:\Program Files\TextPad 6\Textpad.exe" -t"%t" "%f(%l)"
II_WINDOWVIEW="C:\Program Files\TextPad 6\Textpad.exe" -r -t"%t" "%f(%l)"
For N++ there are some syntax colouring files produced by Bodo (I think) available. (attached – I think that’s all there is)
With N++ for some reason (command line flags I suspect at the time) I had to create a batch script interface with symbolic linking to 'get' the component name:
II_W4GL_SYSTEMEDITOR=TRUE
II_WINDOWEDIT=f:\RCBatch\w4gledit.bat %t %f
W4gledit.bat:
@echo off
echo %1 %2 %3 %4 %5 %6 %7 %8 %9
REM Componentname Filenane
REM c:\ingresii\ingres\temp\wa12345.e67
REM w4gledit %t %f
set INGFILE=%4
set INGPATH=%~dp4
set EXT=%~x4
REM DEBUG
echo INGFILE= %INGFILE%
echo INGPATH= %INGPATH%
echo EXT= %EXT%
REM "Script Editor: process_marking_team"
set COMPNAME=%~3
set COMPNAME=%COMPNAME: =%
set COMPNAME=%COMPNAME:ScriptEditor:=%
set W4GLNAME=%INGPATH%%COMPNAME%.script
REM DEBUG
echo COMPNAME= %COMPNAME%
echo W4GLNAME= %W4GLNAME%
echo INGFILE = %INGFILE%
echo W4GLNAME = %W4GLNAME%
echo Do not Close this Window it controls your editor........
REM Symbolically link your file so that you don't have to close the editor
mklink %W4GLNAME% %INGFILE%
REM If there is an error it maybe because the symbolic link name exists - so remove it
if %ERRORLEVEL% == 1 goto :tidyup
if exist "c:\progra~2\Notepad++\notepad++.exe" (
start /WAIT c:\progra~2\Notepad++\notepad++.exe -multiInst %W4GLNAME%
) ELSE (
start /WAIT c:\progra~1\Notepad++\notepad++.exe -multiInst %W4GLNAME%
)
REM Make back up
copy %W4GLNAME% %W4GLNAME%%EXT%
REM Remove the symbolic link - mklink doen't like it if the file already exists.
:tidyup
del %W4GLNAME%
I have been using VS-Code for some python related work which lead me to start using it for SQL as well.
I feel another ‘editor’ movement coming - I previously started looking at how to construct an OpenROAD extension for vs-code.
Now that the nights are drawing in again I might return to that curiosity.
Unless someone on the payroll has already beaten me to that?
Cheers
Adrian
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/a313a426-1e96-4002-b7f6-a76e2e0947eb%40gmail.com.
Allan
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/000a01dafab4%24c2ac25d0%2448047170%24%40rationalcommerce.com.
Adrian Williamson
Hi,
The Scintilla based editor which is used by default can be extended as well.
Only played with this enough to get TABS to manifest as 4 spaces and not the ridiculous 8 it defaults to.
https://github.com/ActianCorp/OpenROAD_plugins_samples
It has not really been released as such (or ‘revenue generation’ would be charging us for it by now) as far as I know.
I had to raise a ticket to get more info on it.
Cheers
Adrian
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/000a01dafab4%24c2ac25d0%2448047170%24%40rationalcommerce.com.
Bodo Bergmann
Apart from OpenROAD.xml that Adrian attached, there is another file involved - the UDL (User Defined Language) file: OpenROAD_UDL.xml
The UDL file has to be imported into the "User Defined Language" dialog in Notepad++.
The OpennROAD keywords have also been grouped into 6 different groups (leaving “Keywords7” and “Keywords8” for customizing):
1. 4GL/SQL language statements (except the “Folding” statements, Comment and Operators)
2. Events
3. System defined constants, variables and macrovariables
4. Datatypes and system classes
5. Attributes/Methods of system classes
6. Functions
The customization of fonts and colours is quite simple – just edit the fontStyle, fontName, fgColor and fgColor attributes of the “WordsStyle” elements within the XML file,
If you want to add new keywords it is simple, too – change the according keywords entry in the file.
You could use an XML Editor, or just Notepad++ to change the XML file.
Of course you can change the styling also afterwards in Notepad++ (in the "User Defined Language" dialog).
For adding your own component/attribute/method names as keywords (e.g. to the 7th and 8th group of the Keywords List) I recomment to extract them from XML export files of your applications.
In order to extract component names from an XML export file (created with II_W4GL_EXPORT_INDENTED=TRUE) you do not even have to use XML parser.
E.g. using simple OS commands – below is an example using Unix commands (I actually used Cygwin on Windows):
grep "<COMPONENT name=" *.exp | cut -f2 -d'"'
In order to get the names of all user class attributes/methods you can use this one:
grep "<displayname>" *.exp | gawk -F">" '{print $2}' | gawk -F"<" '{print $1}' | sort -u
HTH.
Best regards,
Bodo.
Bodo Bergmann Engineering Architect | OpenROAD Engineering Actian, a division of HCLSoftware | |
GESELLSCHAFTSANGABEN: Actian Germany GmbH | Registry Off: Halenreie 42, 22359 Hamburg | Geschäftsführung: Stephen Padgett, Marc Monahan | Handelsregister: Amtsgericht Hamburg | HRB 135991 | USt-IdNr: DE252449897 | |
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/001501dafab7%24ec498010%24c4dc8030%24%40rationalcommerce.com.
Paul White
Play time this weekend.
Paul
&
Allan
I still remember ABF
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/a21977b8-dfef-4ee2-a7d1-63c0e1e3c8f5%40gmail.com.
a...@rationalcommerce.com
I still remember ABF
Allan
--
Sent with mail.com Mail app
Paul White
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/trinity-959ac6e0-2810-43a1-8abf-85dcad5db062-1725034639490%40trinity-msg-rest-gmx-mailcom-live-8794977bf-5qp2k.
_Andy_
Back in OR4.1 days we used an editor called EditPlus (not free) but allowed us to create our own syntax highlight, auto-completion, and integrated some batch scripts using keyboard shortcuts.
My favourite shortcut was - highlight a word (like a table name) and then Ctrl+1 to generate and open a temp file with:
- a help table run on that highlighted table name, and
- a default values listing for each column in that table - like: curobject.<column_name> = <default_value_for_that_datatype>; , and
- the insert/update/delete statements for that table.
Made things a little easier during coding. Added many scripts for other things like generating CSV RW files, Search through DocApp files, etc
Our exe to open EditPlus - took a timestamped before and after copy of the field being edited - as well as a timed BAK file maintained by EditPlus.
Back then we used an AutoIt script to call editplus and we could generate into an EXE file (which always triggered our antivirus software). At some point was going to re-write into C#.
Ingres environment variables looked a little like this:
ingunset II_VIEW
ingunset II_EDIT
ingunset ING_EDIT
ingsetenv II_W4GL_SYSTEMEDITOR TRUE
ingsetenv II_W4GL_COMPILEEDITOR FALSE
ingsetenv II_WINDOWEDIT "%xxdir%\bin\or_edit.exe %%f %%l %%e %%t"
ingsetenv II_WINDOWVIEW "%xxdir%\bin\or_edit.exe %%f %%l %%e %%t -r"
I lost my OR job whilst moving into OR 6.2 - during covid and my next job was back to ABF and SC development......
We can use VS Code in my workplace, but not EditPlus.
So, I am trying hard to create similar syntax highlighting, code completion, function lookup, etc with VS Code for ABF and SC, but I have struggled with creating a decent extension.
I have something basic created but not worthy of sharing.
If someone has something like that - please please please share.
Not sure if the above is helpful, but I just found EditPlus to be so quick and easy to configure.
Kind regards, Andy
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CAPzMTfDkeELsDt%3D6Wg%2BsSe08VmXZBzQva4L%2BF1HxMz4bnF8mmA%40mail.gmail.com.
Allan
My one contract inquiry with OpenROAD, maybe 4 years ago, involved a company moving from OpenROAD to a web-based platform. Confirms what you say.
I decided I couldn't condone this and at , then, 74 years of age couldn't be bothered either. I backed out of the contract. The agent did say they had 3 people with OR experience already working.
Ingres never seemed to promote and actively sell the database or the development tools.
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/c4s3n5dahlv8ujtpoq2vc272.1725037902701%40email.lge.com.