|
From: Patrick N. <pa...@pa...> - 2007-09-11 23:34:10
|
On Sep 11, 2007, at 5:43 PM, Robert Manning wrote: > In the SQL editor, type the query that limits the rows. Then place > your cursor in the query, and type Ctrl-T to access the tools popup. > Next type "sql2ins" - without the quotes : this stands for > sql-to-insert statements. The insert statement should appear at the > end of the editor. Great. Thanks! I kept looking for a script menu on the output pane... >> If not perhaps I can try to add this feature and submit it. > > Perhaps another approach could be to set a "Contents Tab SQL filter" > on the table, then right-click to "Create Data Script" could take into > account the filter criteria. It doesn't currently - > CreateDataScriptCommand.java is the file, if you have time and want to > look. The IObjectTreeApi doesn't provide a good way to get access to > the ContentTab which contains the method getSQLFilterClauses - it > needs to support getting a particular type of tab - the "Contents" > tab; right now it only supports getting a tab by title - not by > purpose. If you would like to study the code a little and suggest an > improvement we would be happy to listen. I will try to dig into the project when I get some time and see if I can help. thanks again, Pat |
