Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#798 Create Data Script from SQL broken in 3.0.2

3.0.2
open
Colin Bell
5
2009-10-12
2009-10-12
Yusuf Reed
No

I know it was working in 2.6.8, the last version I had before upgrading, This can be found in Session-> Scripts->Create Data Script from SQL. What it does is create the field names, but does not include the field values in the insert statement.

Discussion

  • Yusuf Reed
    Yusuf Reed
    2009-10-12

    shows the select and resulting insert statement

     
  • Rob Manning
    Rob Manning
    2009-10-12

    Please provide a script with create table statements and inserts that reproduce the issue. Also, please let us know the database vendor and version ( as well as the jdbc driver version). This information will help us pinpoint the issue.

    Rob

     
  • Rob Manning
    Rob Manning
    2009-10-12

    • labels: 404491 --> SQL Scripts Plugin
    • milestone: --> 3.0.2
     
  • Yusuf Reed
    Yusuf Reed
    2009-10-13

    squirrel bug demonstration

     
    Attachments
  • Yusuf Reed
    Yusuf Reed
    2009-10-13

    We are running Sybase ver 12.5.3 and jtds-1.2.jar.

    I have attached a file of sql that creates a table, inserts a row, selects the row, and then tries to create an insert statement from the select.

     
  • Rob Manning
    Rob Manning
    2010-02-28

    I wasn't able to re-create the problem using the latest snapshot against Sybase 12.5.3 w/ jTDS 1.2. Are you getting any exceptions in the log, and can you verify that the problem still occurs with the latest snapshot ?

    Rob

     
  • I am sorry but I no longer use SQuirreL to follow up.