From: <nn...@us...> - 2007-09-25 16:54:48
|
Revision: 2163 http://tora.svn.sourceforge.net/tora/?rev=2163&view=rev Author: nneul Date: 2007-09-25 09:54:51 -0700 (Tue, 25 Sep 2007) Log Message: ----------- updates from Andreas for sort order and version detection Modified Paths: -------------- trunk/tora/NEWS trunk/tora/src/tooracleconnection.cpp trunk/tora/src/tosession.cpp Modified: trunk/tora/NEWS =================================================================== --- trunk/tora/NEWS 2007-09-25 15:25:00 UTC (rev 2162) +++ trunk/tora/NEWS 2007-09-25 16:54:51 UTC (rev 2163) @@ -1,5 +1,8 @@ 1.3.23: 2007-09-19: removing all Qt < 3.2 support and KDE integration in preparation for future Qt4 work +2007-09-25: update to tostorage.cpp query +2007-09-25: fix broken db version detection +2007-09-05: sort order for long ops 1.3.22: 2006-03-01: Autocompletion first step Modified: trunk/tora/src/tooracleconnection.cpp =================================================================== --- trunk/tora/src/tooracleconnection.cpp 2007-09-25 15:25:00 UTC (rev 2162) +++ trunk/tora/src/tooracleconnection.cpp 2007-09-25 16:54:51 UTC (rev 2163) @@ -829,7 +829,7 @@ try { otl_stream version(1, - "SELECT version FROM product_component_version where product like 'Oracle Database %'", + "SELECT version FROM product_component_version where product like 'Oracle%'", *(conn->Connection)); if (!version.eof()) { Modified: trunk/tora/src/tosession.cpp =================================================================== --- trunk/tora/src/tosession.cpp 2007-09-25 15:25:00 UTC (rev 2162) +++ trunk/tora/src/tosession.cpp 2007-09-25 16:54:51 UTC (rev 2163) @@ -301,7 +301,7 @@ ResultTab->addTab(CurrentStatement, tr("Current Statement")); QString sql = toSQL::string(TOSQL_LONGOPS, connection); - sql += " AND b.sid = :sid<char[101]> AND b.serial# = :ser<char[101]>"; + sql += " AND b.sid = :sid<char[101]> AND b.serial# = :ser<char[101]> order by b.start_time desc"; LongOps = new toResultLong(true, false, toQuery::Background, ResultTab); LongOps->setSQL(sql); ResultTab->addTab(LongOps, tr("Long ops")); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |