Menu

ExtractSchema doesn't work with mssql

Jeff
2004-05-14
2004-05-29
  • Jeff

    Jeff - 2004-05-14

    However the following fix on line 1656 fixes things (and I don't think it breaks anything on the other dba platforms).

    was:
    $rs = $this->db->Execute( 'SELECT * FROM ' . $table . ' WHERE -1' );

    fixed for mssql:
    $rs = $this->db->Execute( 'SELECT * FROM ' . $table . ' WHERE (1=2)' );

    Great project though!  Let me know if I'm off base on the above resolution as I am only moderately versed in SQL.

     
    • Richard Tango-Lowy

      Messing around with AXMLS today--I'll take a look at it. The fix looks reasonable.

      Rich

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.