Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Tasks : Common tasks for supported databases : SQL scripting : Copying and pasting
 
Copying and pasting
Copying and pasting
A Copy Name option is available from most context menus in the DB Structure view and some context menus in the DB Details view. Copy Name copies all selected node labels to the clipboard.
The SQL Results view contains a Copy to Clipboard icon in its toolbar. It also allows the data to be pasted to the clipboard.
The copied contents can be pasted into the SQL Editor, the OpenEdge Editor, or any other Windows-compliant application.
Settings in the DB Navigator preferences page allow you to specify the following variations when pasting:
*Append table name to column - Select this option to automatically append table names to column names when they are pasted.
*Enclose in quotes - Select this option to automatically enclose column names in quotes when they are pasted or when generating a select in SQL Editor.
*Delimiter -Provide the delimiter you want to use when multiple columns are selected. (The default is a comma.)