[Squirrel-sql-users] Export Resultset

[Stefan G. <new...@sg...>]

Hi

using Squirrel 3.5.3 I connect to a MS-SQL 2008R2 DB.
I´ve got a select Script using Variables.
Unfortunately I cannot export the resultset directly to file.

A minimal example Script looks like this:

    declare @A varchar(4);
    set @A = 2014;
    select
    *
    from Table

I expect some 10,000 rows so I want to directly export results but 
Squirrel tells me:
     The selected SQL is not a SELECT statement.
I can see the export window but exporting results throws a 
NullPointerException.

Any hints on how to export a script like this or is this a bug?

Cheers Stefan

2014-09-26 11:30:29,068 [Thread-2] ERROR 
net.sourceforge.squirrel_sql.client.session.MessagePanel  - 
privateShowMessage: Exception was null
java.lang.reflect.InvocationTargetException
     at java.awt.EventQueue.invokeAndWait(Unknown Source)
     at java.awt.EventQueue.invokeAndWait(Unknown Source)
     at javax.swing.SwingUtilities.invokeAndWait(Unknown Source)
     at 
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.createProgressAbortDialog(CreateFileOfCurrentSQLCommand.java:229)
     at 
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$2.create(CreateFileOfCurrentSQLCommand.java:124)
     at 
net.sourceforge.squirrel_sql.fw.gui.action.ResultSetExportCommand.createProgressController(ResultSetExportCommand.java:143)
     at 
net.sourceforge.squirrel_sql.fw.gui.action.AbstractExportCommand.execute(AbstractExportCommand.java:257)
     at 
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.doCreateFileOfCurrentSQL(CreateFileOfCurrentSQLCommand.java:136)
     at 
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand.access$000(CreateFileOfCurrentSQLCommand.java:58)
     at 
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$1.run(CreateFileOfCurrentSQLCommand.java:93)
     at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
     at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
     at 
net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformatorKernel.getStatesOfPosition(CodeReformatorKernel.java:188)
     at 
net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformator.flatenWhiteSpaces(CodeReformator.java:597)
     at 
net.sourceforge.squirrel_sql.client.util.codereformat.CodeReformator.reformat(CodeReformator.java:56)
     at 
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateFileOfCurrentSQLCommand$4.run(CreateFileOfCurrentSQLCommand.java:240)
     at java.awt.event.InvocationEvent.dispatch(Unknown Source)
     at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
     at java.awt.EventQueue.access$200(Unknown Source)
     at java.awt.EventQueue$3.run(Unknown Source)
     at java.awt.EventQueue$3.run(Unknown Source)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown 
Source)
     at java.awt.EventQueue.dispatchEvent(Unknown Source)
     at 
net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
     at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
     at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
     at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
     at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
     at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
     at java.awt.EventDispatchThread.run(Unknown Source)