When you first start the editor, the following tabs will be available:
When you click Execute, the SQL code of the currently visible tab will be executed. You can also execute just part of the code by 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.
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 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.
Similarly, you can highlight a myDBR command and click Show Object and you will be shown the manual page of that particular command so you can check the usage and parameters.
To open the preferences, click the cog icon in the top right. The preferences there are:
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.