Table of Content
Tutorial

How do I save script?

Just select "Script->Save" item in the menu of the main program window. You will be asked to enter the name of the file if the file being edited was created with the "New file" command.

Execute "Script->Save as" command when you want to save the file with a different name. The dialog that follows will allow you to change the directory and specify the name for the current file. Pay your attention to the preview capability of this dialog, so you don't overwrite necessary file(s) or script(s).

Every time you make any changes in the file and decide to exit the program, you will be warned and asked about saving this file with several options provided.

If auto save feature has been enabled, the program periodically will save the contents of the current file into "autosave.tmp" that can be found in the program's directory (for ex. C:\Program Files\SQLedit\autosave.tmp).

How do I load existing script?

When running the program, you have to select "Script->Load" menu item in the main window to load the script file. "Open File" dialog allows you to preview SQL script before the file is loaded into the editor.

Specifying the filename as an argument in the command line. For example: se.exe MySQLscript.sql

Using drag-n-drop. If you have the program running, simply grab the file and drop it anywhere inside the main window. Otherwise, drop it onto the program's shortcut icon (located on the Desktop or in the folder you placed it in) - and the program will start with the file loaded into the editor.

Using Edit history. "Load" toolbar button has the special drop-down menu, which lists the files you have edited last time. Selecting the file from the menu and it will be loaded again.

How do I get and view the results of script execution?

If the SQL script being executed produces the resulting recordset, you can view it in the "Results" pane of the main window. It allows you to:

  • list the record set one record by one or page by page;
  • set the width of columns representing the fields of records;
  • see the current record number.

Placing the mouse cursor over the column header will tell you the type of data stored in this field.

How to select a database to connect to?

Please use "plus" toolbar button or Connect menu item for open "Connect" dialog to select Interface (ODBC, IDAPI or OCI), Data source or alias name, user name and owner name.

Some types of DBMS require user name (login) and access password to be specified. When you want to access the tables belonging to one data scheme (or owner), you should fill the "owner" entry, otherwise all tables will be accessed.

Important! Database name selection support works only for Microsoft SQL Server 6.5 or higher.

See also FAQ