Using SQL Editor

When you first start the editor, the following tabs will be available:

Original
When editing an existing stored procedure, this tabs contains the source code as it was before you started editing. This is useful for restoring the original version of the source code in cases where you want to revert back the original code.
Editing
The source code of the stored procedure.
Query 1
This is used for executing additional SQL statements. Usually you would call the stored procedure from here. If needed you can add more tabs by clicking '+'. Click '-' to remove unnecessary ones.

Executing statements

When you click Execute, the SQL code of the currently visible tab will be executed. You can also execute just part of the code simply selecting part of the script and clicking Execute. You will see the results and possible error messages on the lower part of the page.

You can execute multiple statements at once by adding a command delimiter between the commands. The delimiter for MySQL is '$$' and 'go' for MS SQL Server, Sybase ASE and SQL Anywhere.

Show selected object

When you create myDBR reports, you often call other procedures, functions or want to see table definitions. If you highlight a procedure name, function name or a table name and click Show Object, you will get the source code/table definition in a new tab. This allows you to see parameters / table definitions you might need in the report making.

Similarily you can highlite a myDBR command and click Show Object and you will be shown manual page of that particular command so you can check the usage and parameters.

Editor preferences

To open the preferences, click the cog-icon in top right. The preferences there are:

Theme
You can choose the theme for editor. This will include the colors used, no changes in behavior.
Indent with spaces
Determines if using TAB in editor produces spaces or TAB
Keymap
In addition to normal keymap, you can use keymapping from favourite editors (Emacs, Sublime Text, Vim)
Autocomplete databases
Choose the database for which the autocomplate is available

Using autocomplete

Select the databases whose structure you wish to autocomplete from editor preferences. Type start of the object/column name and use Ctrl (Cmd on Mac) - Space to bring up the autocomplete suggestions-

You can have a separate window for SQL Editor open and run the report on another window while you work. This way you will see the changes immediately after the browser refreshes.