How to customize "export results" - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer How to customize "export results"

Print Thread

How to customize "export results" #64433 02/13/23 07:35 AM
Joined: Jun 2015 Posts: 72 Russia L lost OP Member
OP lost Member L Joined: Jun 2015 Posts: 72 Russia	I want to have an export option as SQL not as list of INSERT-s, but as a MERGE. It seems that I should export "Export" functions from my plugin dll. But how to know the data source (commonly table name) of the result? Last edited by lost; 02/13/23 07:36 AM.

Re: How to customize "export results" lost #64434 02/13/23 09:18 AM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	This information is not available from the Plug-In interface. You would need to parse the SQL text of the editor. Marco Kalter Allround Automations

Re: How to customize "export results" lost #64436 02/13/23 12:42 PM
Joined: Jun 2015 Posts: 72 Russia L lost OP Member
OP lost Member L Joined: Jun 2015 Posts: 72 Russia	It is very sad. I don't know how to determine last executed SELECT-statement in PLSD. Thanks anyway... But PLSD have a Code \Scripts\ExportResultsToSQLInitialization.sql template and Code %TABLENAME% variable in it. Maybe there is some way to get it's value in plugin without parsing? And what kind of additional info hidden under this statement of documentation? Quote Plug-In Export functions Not all functions related to export functions are described yet. If you want to create your own data export module, just let us know and we will give you some additional information. Last edited by lost; 02/13/23 12:46 PM.

Re: How to customize "export results" Marco Kalter #64439 02/14/23 08:27 AM
Joined: Jun 2015 Posts: 72 Russia L lost OP Member
OP lost Member L Joined: Jun 2015 Posts: 72 Russia	Originally Posted by Marco Kalter This information is not available from the Plug-In interface. You would need to parse the SQL text of the editor. Marco, please add parameter to ExportInit() with value of %TABLENAME% template variable, as it made in common "Export Results as SQL file"

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.047s Queries: 14 (0.014s) Memory: 2.5140 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-19 12:20:54 UTC
Valid HTML 5 and Valid CSS