Re: Export rows as sql?

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/