hi ,

here is a diff of a change i have made to ensure sql tasks work with Sybase
and Microsoft, it was tested against Sybase only but I assume since
Microsoft uses TSQL as its command language that the same problem exists
there

i inserted these lines at l448 after the existing line
                if ( line.length() > 2 ) {
                  if (line.substring(0,3).equalsIgnoreCase("REM")) continue;
                }

diff follows

diff -r1.17 SQLExec.java
447a448,456
>                 // Sybase ASE and MS SQL Server use 'go' or 'GO'
>                 // to indicate the end of a statement
>                 if (line.trim().equalsIgnoreCase("go")){
>                     log("SQL: " + sql, Project.MSG_VERBOSE);
>                     execSQL(sql, out);
>                     sql = "";
>                     continue ;
>                 }
>

rgds, tim

Reply via email to