This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | [65cat] Provide Ability to Export SQL Statements in SQL History window | ||
---|---|---|---|
Product: | db | Reporter: | adam_myatt <adam_myatt> |
Component: | SQL Editor | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED FIXED | ||
Severity: | blocker | CC: | romanmostyka |
Priority: | P3 | Keywords: | NETFIX, PATCH_AVAILABLE |
Version: | 6.x | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | ENHANCEMENT | Exception Reporter: | |
Bug Depends on: | |||
Bug Blocks: | 152828 | ||
Attachments: | proposed patch v1 |
Description
adam_myatt
2008-08-20 01:45:01 UTC
Currently, if you select a row in the table, both a subset of the SQL plus the timestamp can be copied to the clipboard by selecting the rows and then using Ctrl-c to copy. If time, I'll see if the entire SQL without the timestamp can be copied. Export can work in this way: 1) Select a connection in DB Explorer and choose Execute Statement 2) Open SQL History then select those statements to "export" then click Insert 3) The statements are exported to the SQL editor and which is saved as a file in the userdir under config/Databases/SQLCommands (the file name is in the title of the editor) FYI, I think this is a fairly significant enhancement and I'm not sure we should be doing it right now. There is a way to export statements by selecting several statements then inserting them in an SQL Editor won't be addressed in 7.0 Actually it is a workaround and it is inconvenient since it requires several actions. Reassigned to new owner. Created attachment 134656 [details] proposed patch v1 The attached patch implements Johns suggestion - copying the selected statements without including the timestamp. (comment #1) This is not a full featured export, but that was not requested - For a more advanced export you will have to add comments and so on, so Johns idea (comment #2) combined with saving the resulting document holds true. The patch works fine. Thank you again. Applied as http://hg.netbeans.org/core-main/rev/261bee78e627 Integrated into 'main-golden', will be available in build *201305212300* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/261bee78e627 User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #144507: Export SQL Statements in SQL History window Patch by Matthias42. |