Online Documentation for SQL Manager for InterBase/Firebird

Execute Script

Abort script on error

If this option is checked, script execution is aborted if an error occurs.

Note: Errors of CONNECT and CREATE DATABASE statements abort script execution anyway.

 

Show statements explorer

With this option checked, Execute Script Editor parses the loaded script to enable fast navigation in the Script Explorer tree.

 

Show message when done

Displays a message box on finishing script execution.

 

Execute selected text separately

Check this option to allow execution of the selected statement separately.

 

Don't clear error list on selected text execution

If this option is checked, the error list is not cleared upon execution of the selected statement.

 

Skip unknown statements

Skips unknown statements on script execution.

 

Disable all code features in Execute Script

Disables syntax highlighting and code folding to speed up processing of script.

Database options

Register databases if needed

If the option is enabled, the Database Registration Info dialog will be displayed automatically after successful CREATE DATABASE or CONNECT script execution.

Note: Unregistered databases mentioned in the CONNECT and CREATE DATABASE statements will be prompted for registration.

 

Connect automatically to just created database

Enable this option to automatically connect to just created database in DB Explorer.

 

Transaction options

Rollback current transaction on abort

This option evokes automatic rollback of the current transaction when script execution is aborted (due to an error or if interrupted by user).

 

Start transaction automatically if needed

Enable this option to automatically start transaction on execution.

 

Toggle AutoDDL off by default

Toggles the default mode (on/off) for automatic committing of each statement.

 

Script finalization

Commit all active transactions automatically

All transactions are committed automatically after the script has been executed.

Ask user to select required action

The user is prompted to commit or abort transaction after the script has been executed.

 

---