We are currently updating the OP Help Center content for the release of OP 14.19 or "OP 19". OP 19 is a member of the certified OP 14 family of products (official version is 14.19.1), which you may see in your software (such as in Help > About) and in the Help Center tabs labeled 14.19. You may also notice that the version number in content and videos may not match the version of your software, and some procedural content may not match the workflow in your software. We appreciate your patience and understanding as we make these enhancements.

How to Clip and Save 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.  Simply perform the following:

  1. Select the SQL article from the Clip-and-Save SQL Library for the code you want to copy.
  2. Locate and click the Copy button in the SQL article. Your code will be highlighted and copied to your clipboard by simply clicking the Copy button.
  3. Click the Tools tab > Database Viewer button.  Open your OP Database Viewer.
  4. Select the SQL tab.
  5. Paste the code into 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.

That's it!  The process of Pasting and Saving your Code is shown below.

Version 14.10

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

  1. Select the SQL article from the Clip-and-Save SQL Library for the code you want to copy.
  2. Locate and click the Copy button of the SQL article. Your code will be highlighted and copied to your clipboard by simply clicking the button.
  3. Open your OP Database Viewer.
  4. Select the SQL tab.
  5. Paste the code into 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.

That's it!  The process of Pasting and Saving your Code is shown below.