Use forward only cursor in all queries

qgis · Mar 28, 2012 · f375e35 · f375e35
1 parent f07b3f9
commit f375e35
Showing 1 changed file with 2 additions and 0 deletions.
diff --git a/src/providers/mssql/qgsmssqlprovider.cpp b/src/providers/mssql/qgsmssqlprovider.cpp
@@ -354,6 +354,7 @@ void QgsMssqlProvider::loadFields()
     if ( mFidColName.isEmpty() )
     {
       mQuery.clear();
+      mQuery.setForwardOnly( true );
       if (!mQuery.exec( QString( "exec sp_pkeys N'%1', NULL, NULL" ).arg( mTableName ) ))
       {
         QString msg = mQuery.lastError().text();
@@ -370,6 +371,7 @@ void QgsMssqlProvider::loadFields()
       foreach( QString pk, pkCandidates )
       {
         mQuery.clear();
+        mQuery.setForwardOnly( true );
         if (!mQuery.exec( QString( "select count(distinct [%1]), count([%1]) from [%2].[%3]" )
             .arg( pk )
             .arg( mSchemaName )