Important Content Update Message
We are currently updating the OP Help Center content for the release of OP 20. OP 20 (official version 20.0.x) is the certified, 2015 Edition, version of the Office Practicum software. This is displayed in your software (Help tab > About) and in the Help Center tab labeled Version 20.0. We appreciate your patience as we continue to update all of our content.

Clipping and Saving from the Clip-and-Save SQL List

Version 14.19

Clipping and Saving from the Clip-and-Save SQL Library to the OP Database Viewer is very easy:

  1. Select the SQL Article from the Clip-and-Save SQL Library for the code you want to copy.
  2. Click the Copy button in the SQL article. This highlights and copies your Code to your clipboard.
  3. Click the Database Viewer button. The OP Database Viewer is displayed.
  4. Click the SQL tab.
  5. Paste the Code in the SQL field.
  6. Click the Save SQL Query Text Under a New Name button .
  7. Enter a Name for your SQL Query.
  8. Run your new SQL code.

The process of Pasting and Saving your Code is displayed below.

Version 14.10

Clipping and Saving from the Clip-and-Save SQL Library to the OP Database Viewer is easy:

  1. Select the SQL Article from the Clip-and-Save SQL Library for the code you want to copy.
  2. Click the Copy button in the SQL article. This highlights and copies your Code to your clipboard.
  3. Click the Database Viewer button. The OP Database Viewer is displayed.
  4. Click the SQL tab.
  5. Paste the Code in the SQL field.
  6. Click the Save SQL Query Text Under a New Name button .
  7. Enter a Name for your SQL Query.
  8. Run your new SQL code.

The process of Pasting and Saving your Code is displayed below.