Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I cut, copy, and paste into the “Enter SQL Statements…” window?

April 26, 2017copy cut paste window

0

Posted

How do I cut, copy, and paste into the “Enter SQL Statements…” window?

1 Answer

0

Posted

When the Report Designer is running as an Applet, java applet security prevents Report Designer from accessing the system’s clipboard. Therefore, even though cut, copy, and paste works within the Applet, it cannot obtain data from an external source. This becomes a problem when the user wants to copy and paste long SQL queries from a text file into the Designer. The way to solve this problem is to set the java applet security policy so that the Designer is granted permission to access the System clipboard. To do so, go to your JRE security directory (if you have multiple versions, use the one set up for your browser), on Windows this is typically located in the C:\Program Files\Java\j2re*\lib\security\.