Script Editor
To open Script Editor open a database, then tap "Run Query" button.
Also Script Editor can be opened by tapping "Edit script" button in a View view, Trigger view or Index view.
* Note that a Script Editor opened from View view, Trigger view or Index view hides its Result view and appropriate button, also it hides "Run"(->) button as they are not needed.
In Script Editor switch to Query view. Type an SQL command sequence splitted by ","(comma) character. Then tap "->"(Run) button. Your query will be executed. You can see results on Result view.
SQLite reference can be accessed from Script Editor. Read more on "SQLite reference".
To clear all text on Script Editor tap on "X"(Clear) button.
To hide screen keyboard tap on "Hide Keyboard" button.
Saving scripts
To save a script in a file tap on "Save" button. In the popped dialog choose a method you prefere.
If you select "New file" option, you'll be asked for a new file name to. Note that "*.txt" extension will be added to the filename automatically.
If you select "Existing file" option, File Browser view will pop. After you select a file, the file content will be replaced by the new content.
Opening scripts
To open a script from a file tap on "Open" button. File Browser view will pop. After you select a file, the file content will be opened in Script Editor.
Generating DDL
To generate a DDL script tap Generate DDL button on Database view.
A Script will be generated and opened in Script Editor.
The generated script will describe database structure and containing data.
Now you can save it to a file.
Script Editor settings
To edit Script Editor settings tap on "Settings"(Hummer and screwdriver) button Script Editor Settings view will pop.
Read more on "Script Editor Settings".