
Documentation

dataPro

Prev: Import Excel Spreadsheets to the Database

dataPro™ Commands Overview

File

New	Opens a new document in the edit window
Open	Opens a file
Save	Saves content of the carrent editor to the file
Save As	Saves content of the current editor to a new file
Open Recent	Displays list of the recently open documents
New Tab	Creates new editor tab
Close Tab	Closes current Editor window
Print	Print the content of the current Editor
Exit	Exits the program

Edit

Undo	Undo text operation.
Redo	Redo text operation.
Cut	Cut selected text.
Copy	Copy selected text.
Paste	Paste text.
Delete	Delete selected text.
Select All	Select All text.
Find	Find text string.
Replace	Replace text string.
Paste SELECT	Paste SELECT statement for the choosen table.
Paste INSERT	Paste INSERT statement for the choosen table.
Retrieve Create SQL	Retrieve create statement for database object.

View

Toolbar	Hide or show toolbar.
Status Bar	Hide or show status bar.
Line Numbers	Hide or show line numbers in the Editor.
Flip Panels	Switches tree view from left to right.
Result in New Window	When selected the new table window will be created every time for a new resultset.

Database

Add	Invokes an Add Database dialog box. Allows user to add database to the tree window.
Remove	Removes host from the configuration file. Does not affect the databases in any ways.
Order	Sorts tree view items in alphabetical order.
Reconnect	Reconnects to the current database.
Create	To create a new database or a table.
Copy	Selects object for copying.
Paste	Creates a new object according to a previously selected object.
Paste Table Schema	Creates a new table with the structure copied from the existed table.
Paste Table Data	Copies data to a new table.
Rename	Rename a table or a view.
Drop	Drop a database or a database object.
Return Top 100 Rows	Returns top 100 rows from a table or a view.
Return All Rows	Selects all rows from the table or a view.
Retrieve SQL	Retrieve code for stored procedure, function, view or trigger.
Refresh	Reconnects to the database.
Properties	Shows the connection properties for the host or table structure.

SQL

Execute	Executes the highlighted SQL statement on the database.
Run Script	Runs the loaded script.
Show Last Error	Shows last error for the current connection.

Table

Copy	Copies the content of the highlighted cell in the table view to the clipboard.
Copy Row	Copies the content of the highlighted row in the table view to the clipboard.
Find	Search for a string in the table.
Edit	Edit cell (Doble click on the cell will do the same).
Delete Row	Deletes highlighted row from the database table.
Save Table As	Saves the result of the SQL Select statement to the file.
Save Field As	Saves the content of the selected field to the file.
Refresh	To refresh content of the table window.
Close	Closes the current table window.

Tools

Import Text Files	To import comma delimeted file to the database.
Import Excel Files	To import Excel spreadsheets to the database.

Help

Contents	Opens this help.
Help Index	Opens the help index.
dataPro on the Web...	Opens the dataPro website.
About dataPro...	About dialog box.

Prev: Import Excel Spreadsheets to the Database

Services | Products | Support | Downloads | Contact Us | About Us | Site Map
Copyright 1998-2009 Vive Corp. All rights reserved.