BaseNow

 

  Search
   

  Help

Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues

  Support

 Forums

Technical support

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data

  Subscribe

Stay informed about any major changes. Click here to subscribe

 

Run SQL

Run SQL is a tool that allows you to write SQL statements and execute them against the database. It is very easy to use and is quickly accessible. It does not use the elements that allow you to visually generate SQL statements like SQL Query Builder. Instead, it executes ready-to-run statements and creates views using them. To open the Run SQL tool, press the Run window on the toolbar:

... a window will be displayed, like on the picture below. You write the SQL statements in the text box and execute them against the data source by pressing the Run button.

Executing multiple SQL statements

You can combine more than one statement by separating each statement with the keyword GO on a new line. For example, the program will split SQL statement below into two separate commands. The first line will be executed first and the NewCustomers table will be deleted. After that, SELECT INTO statement will create a new table and copy all records from the Customers table.

Creating a view using specified SQL statement

If you write an SQL statement that you would like to save as a view in a database, you can select the 'Create a view using this SQL statement' check box. The program will prompt you for a name of the view and after you press OK it will create the view in the database using the SQL statement you specified in the Run SQL window.

Previous SQL Statements

Previous SQL Statements drop down list at the top of the window contains last 10 executed SQL statements. It can save your time by inserting a ready-to-use SQL statement at the cursor position in the text box. The lenght of the SQL statement must be less than 5000 characters in order to be saved to the list.

How to dock the Run SQL window

The Run SQL window is dockable and it can be arranged like on the picture below. When you reopen the program it will remember the layout of the main window and display the Run SQL tool.


Related Topics:

About SQL Query Builder

Execute SQL Query tool

Group records

 

[Home] [Download] [Screen Shots] [Details] [Support] [Purchase]

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.