SQL SCRIPTING

The user can execute any SQL statement typed in the TEXTAREA form. Multiple queries must be separated with semicolon. Everything written in the TEXTAREA can be saved as a file. The list of the saved scripts is displayed in list (on the left). Any script can contain any number of SQL queries, separated with semicolon.

The script can be loaded into TEXTAREA for execution and editing, then it can be executed, closed, saved or saved as new script and deleted. When the script is being closed the user is not prompted to save changes - be careful!

FILE OPTIONS
Open	Load script and run it.
Close	Unload script.
Delete	Delete selected script.
Edit	Load script into the Textarea, where it can be executed and edited.
Rename	Rename the file
Sort by	Sort scripts
SCRIPT OPTIONS
Execute	Execute loaded script
Abort on error	Execution of multiple query will be stoped if error occurs
Save	Save the opened Script
Save as	Save new Script or Save opened script with different name

Executed script displays the result on the same page. Only "Select" like SQL statements will display their output as a table. Otherwise only the status of the executed statement will be shown.

If there is more than one SQL statement in the script, the result of the execution of each statement will be displayed. See the picture below:

You can modify the script and execute it again, save, save as new script, return back or print the output of each statement separately.

The "Print result" form appears only for "Select" like statements.

The following printing options are available:

• Enter the page title as the header of the printout.
• Title text style (Bolt, Italic and Underlined).
• Title alignment: Left, Right or Center.
• Height of the table header and height of the table rows: (min., 20 pixel, 30 pixel).

Previous TOC Next

 

 [Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]

Copyright © 2003 cgiscriptshop.com