Using SQL Command Line Interface

SQL Command Line Interface is a part of dataPro. It can be used to interact with the database. User can execute any SQL command that is supported by the current Database type. For example "Select * from Companies". The result of the select query will be shown as a formatted table. Any other SQL command does not produce a visual result. To execute a command user should type the SQL statement in the Edit window and either hit the Ctrl and Enter buttons on the keyboard, click on the Execute (Run) button or select Execute menu item from the SQL popup menu. If there are more than one Sql query in the edit window the editor will execute the query based on the cursor position. User can force the program to execute any SQL statement by highlighting it. User can save the entire content of the Edit window to the file or load the text file by using File popup menu commands.