|Previous Top Next|
The Special Copy and Special Paste feature is accessible from the main menu via Edit | Special Copy or Edit | Special Paste. You can use the default, one of the pre-defined options or the Custom menu option. The default option and pre-defined ones can be customized in the Preferences.
This functionality can be used if you want to copy text from Database Workbench to your programming environment, so that it can be pasted directly into your source code.
Here's an example:
Let's "special copy" this to several programming languages, with default settings:
If you select Edit | Copy Special | Copy Special Custom, a dialog will be shown allowing you to modify the current way of copying things.
(click image to expand)
In this dialog, you can customize the current copy action.
To paste from your favorite programming language into Database Workbench, you can use the Special Paste functionality, it's default settings can be found in the Preferences.
The idea is to strip the SQL from any programming language specific things and get a plain SQL statement, this is done by only grabbing the text between "string markers", eg the single quote character, and replacing programming language specific escape sequences by SQL specific escape sequences.
For example, when copying from Delphi, the text between single quotes is taken and double single quotes are replaced by single quotes.
If you select Edit | Paste Special | Paste Special Custom, a dialog will be shown allowing you to modify the current way of pasting.
In this dialog you can customize the current paste action.