[Context: trying to diaply the result of an EXPLAIN in DbVisualizer] > okay, i've applied the path and trie it: > I use DbVisualizer 2.1 for testing. for normal select it automatically > shows the ResultSet. when i prepend "EXPLAIN" it pops up a > window "Rows > affected: -1" (as it would normally do for INSERT/UPDATE).
It seems as if DbVisualizer is looking for a SELECT in the SQL command to use executeUpdate () and executeQuery (), instead of relying on the return value of execute (). Statement(49249e)::executeUpdate (explain select * from messages where msgno = 700) <-executeUpdate: -1 Statement(5bb83a)::executeQuery (select * from messages where msgno = 700) <-executeQuery: com.sap.dbtech.jdbc.ResultSetSapDB@1c135c I'm going to ask the DbVisualizer developers why, but I guess this turned out to be the most portable way. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
